Hi Tom,

Recently we updated from Oracle 11g to Oracle 12c. After the update we've been having problems with CLOB fields. When we are trying to SELECT a CLOB field from a table in the remote DB inside a procedure it throws an error:

ORA-06000: internal error code, arguments: [kpdb-bad-pdb],[29293],[3],[],[],[],[],[],[],[],[],[]
ORA-06512: at "SYS.DBMS_LOB", line 1092.

We had the same problem when we were using 11g but we were able to overcome that problem using the following workaround:
dbms_lob.substr( ( select DESCRLONG from dual ), 4000, 1 )

DESCRLONG is the CLOB field in the remote db table.

We tried the same trick in 12c but it throws an error. I would really appreciate it if you could provide me with a solution.

Thanks and regards,
Sam