ORA-00600 [kollasg:client-side tmp lob]

今天在檢視一個庫的日志時，發現被ORA-00600 [kollasg:client-side tmp lob] 錯誤刷屏了。

發生該錯誤的原因是因為應用那邊lob的問題。lob沒有被初始化，建議使用EMPTY_CLOB函數對其初始化

mos上原文：

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.