Unfamiliar oci error

The popup, after trying to execute a query, is

This type of result set or referenced data types are not supported.

Then the description in the message box is:

Define: OCI Error (24360): OCIDefineObject
ORA-24360: Type Descriptor Object not specified for Object Bind/Define;

So far, the only 'advice' from web searches is

invoke the OCIBindObject() or OCIDefineObject() call with a valid Type Descriptor Object.

, but I have no idea what this means.

I'm able to run the query in Sql Developer.

	Code:
	SELECT APP.* FROM DB.APPLICATION APP JOIN DB.SUBMITTED_APPLICATION SUB ON APP.SUBMITTED_APPLICATION_ID = SUB.SUBMITTED_APPLICATION_ID ;

It sounds like one or more columns in the referenced tables are having OBJECT type, maybe a custom TYPE. They cannot be retrieved into a grid, they need to be "expanded" to specific elements.

CREATE TYPE my_type IS OBJECT(
field_a NUMBER,
field_b NUMBER,
field_c NUMBER);

if col_a in my_table has type my_type
SELECT col_a.field_a, ... FROM my_table ...

Thanks, Sysop. It might be the CLOB or XML fields. So I removed the wildcard * and specified individual fields. Looks fine.

Regards,

	SysOp wrote:
	It sounds like one or more columns in the referenced tables are having OBJECT type, maybe a custom TYPE. They cannot be retrieved into a grid, they need to be "expanded" to specific elements. CREATE TYPE my_type IS OBJECT( field_a NUMBER, field_b NUMBER, field_c NUMBER); if col_a in my_table has type my_type SELECT col_a.field_a, ... FROM my_table ...