![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
SqlExplorer
Joined: 18 Sep 2011 Posts: 103 Country: United States |
|
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.
![](templates/GreenTech/images/code_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
SELECT
APP.*
FROM
DB.APPLICATION APP
JOIN
DB.SUBMITTED_APPLICATION SUB
ON
APP.SUBMITTED_APPLICATION_ID = SUB.SUBMITTED_APPLICATION_ID
;
|
|
|
Wed Sep 27, 2023 2:59 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7854
|
|
|
|
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 ...
|
|
Wed Sep 27, 2023 4:03 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SqlExplorer
Joined: 18 Sep 2011 Posts: 103 Country: United States |
|
|
|
Thanks, Sysop. It might be the CLOB or XML fields. So I removed the wildcard * and specified individual fields. Looks fine.
Regards,
![](templates/GreenTech/images/quote_header.gif) |
![](templates/GreenTech/images/spacer.gif) |
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 ... |
|
|
Wed Sep 27, 2023 5:08 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|