首页 > 代码库 > ORA-00600 [kollasg:client-side tmp lob]

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)ORA-00600 [kollasg:client-side tmp lob]  - 第1张  | Life Is Easy转到底部ORA-00600 [kollasg:client-side tmp lob]  - 第2张  | Life Is Easy

 

 

 

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]