数据库

 首页 > 数据库 > MySql > 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 t...

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]
分享到:
TNS-12555 / TNS-12560 / TNS-00525 Erro...
TNS-12555 / TNS-12560 / TNS-00525 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPR TNS-12555 / TNS-12560 / TNS-00525 Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))   Problem: LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 21-SEP-2011 12:54:...
4.事务提交过程,事务基本概念,Oracle中...
4.事务提交过程,事务基本概念,Oracle中的事务生命周期,保存点savepoint,数据库的隔离级别 事务提交过程 事务 基本概念 概念:一个或者多个DML语言组成 特点:要么都成功,要么都失败 事务的隔离性:多个客户端同时操作数据库的时候,要隔离它们的操作, 否则出现:脏读  不可重复读...
  •         php迷,一个php技术的分享社区,专属您自己的技术摘抄本、收藏夹。
  • 在这里……