ORA-00600 [kollasg:client-side tmp lob] Fetching Row With LOB Column in OCI Application (文档 ID 1418135.1)
转到底部
In this Document
Symptoms
Cause
Solution
APPLIES TO:
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 [kollasg: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.
![ORA-00600 [kollasg:client-side tmp lob] - 第1张 | Life Is Easy](file:///C:/Users/lenovo/AppData/Local/Temp/enhtmlclip/Image.gif "ORA-00600 [kollasg:client-side tmp lob] - 第1张 | Life Is Easy")
转到底部![ORA-00600 [kollasg:client-side tmp lob] - 第2张 | Life Is Easy](file:///C:/Users/lenovo/AppData/Local/Temp/enhtmlclip/Image(1).gif "ORA-00600 [kollasg:client-side tmp lob] - 第2张 | Life Is Easy"){kind=small}