Hi,

I have encountered a problem which looks like it is OCI, but there may be a workaround.
If I have a query which returns rows of type CLOB when using a SQL*Net client, when TOracleQuery.Describe is called, odescr() returns an ORA-3115 (unsupported network datatype or representation). Similarly, if one of the columns is a nested table, I get ORA-01024 (invalid datatype in OCI call) from odescr()

Is there a work-around so that I can describe queries containing Oracle 8 objects via an Oracle 7 client? I do not need to fetch the data for these columns of course, but I do need to get the column list so I can fetch all the other columns.

Thanks

I don't think OCI7 can describe this select statement for you. Your program either needs to examine the dictionary to determine which columns are OCI7 compatible, or it needs to retry the query until you have filtered out all abusive fields.

------------------
Marco Kalter
Allround Automations