程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> ORA-00600[kollasg:client-sidetmplob]

ORA-00600[kollasg:client-sidetmplob]

編輯:Oracle教程

ORA-00600[kollasg:client-sidetmplob]


今天在查看一個庫的日志時,發現被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張  轉到底部 ORA-00600 [kollasg:client-side tmp lob]  - 第2張

 

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.

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved