The ORA-00600 [kollasg: client-sidetmplob]

The ORA-00600 [kollasg: client-sidetmplob]

Today, when I checked the log of a library, I found the screen was flushed by the ORA-00600 [kollasg: client-side tmp lob] error.

The cause of this error is the lob problem on the application side. Lob is not initialized. We recommend that you use the EMPTY_CLOB function to initialize lob.

Original mos:

ORA-00600 [kollasg: client-side tmp lob] Fetching Row With LOB Column in OCI Application (Document ID 1418135.1)

Go to the bottom

 

In this Document   Symptoms   Cause   Solution   Applies: Oracle Database-Enterprise Edition-Version 11.1.0.6 and later Information in this document applies to any platform. SYMPTOMS An OCI-based application compiled with the 11.1.0.7 client [connecting to 11.2 db] reading a CLOB field being fetched using OCISmtFetch2 fails with an ORA-00600 [kolg: client-side tmp lob]. CAUSE The CLOB field being fetched needs to be initialized, as when fetching a uninitialized LOB column (ie) without any LOB locator is causing the ORA 600 error. SOLUTION Initialize the CLOB field/column with empty_clob (), either on INSERT or after the row is inserted via an UPDATE.