Home » Developer & Programmer » Precompilers, OCI & OCCI » "ORA-03106" error on trying to retrieve CLOB columns whose default value is set to EMPTY_CLOB(). (Oracle Version: 11.2.0.2.0 ;Operating System: Solaris 10)
"ORA-03106" error on trying to retrieve CLOB columns whose default value is set to EMPTY_CLOB(). [message #579492] Tue, 12 March 2013 10:31
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Hello All,

We have 2 clob columns in one of the table and its default value is set to EMPTY_CLOB().

Performing a select(retrieve) of those columns using ProC-OCI is throwing the below error, eventhough we have 2 records.

Error fetching from table.
SQL> FETCH SelectCursor USING SQL DESCRIPTOR SelectBindDesc_
ORA-03106: fatal two-task communication protocol error. (Code=-3106) (Position=0)
[select sraddcmds from cfg1]

However, on setting CLOB values to to ' ' (NULL), I am able to retrieve both the records.

Can you please clarify as why I am getting "ORA-03106" error?

Environment:
Oracle Version: 11.2.0.2.0 ;Operating System: Solaris 10

Thanks
Sunil Kumar
Previous Topic: C++ - migrated from 32 bit to 64 bit and getting unrelated sqlcode while dealing with Oracle DB
Next Topic: ODCIIndexInsert parameters
Goto Forum:
  


Current Time: Thu Mar 28 18:22:57 CDT 2024