"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
|
|
|