TOracleDataset ORA-600 using XMLType and 10.2.0.2

[ldsandon]

I am testing my application with Oracle 10.2.0.2.0 (both client and server). When using a TOracleDataset (DOA 4.0.7.1, D7) to read a table with an XMLType field I get:

ORA-00600: internal error code, arguments: [kolrrdl:0rfc], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_LOB", line 803
ORA-06512: at line 7

A strange thing: when I try in the SQL Editor, sometimes the first record is fetched, and only econd gives the error when trying to fetch the XML field.

It does not happen in Quest's SQL Navigator our DBA uses, and it does not happen if I try against a 9.2.0.6 database (same 10.2.0.2 client).

I see DOA treats XMLType like CLOBs, not native types.

 

[ldsandon]

There is a bug filed in metalink: 4745114 (the reporter uses DOA too). There are workaroaunds, don't know if they are applicable to DOA.

 

[ldsandon]

This issue should be solved in 10.2.0.3 Patch 3 (patch number 5916257). Don't know for previous releases.