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张](http://www.2cto.com/uploadfile/2014/1013/20141013092252809.gif "ORA-00600 [kollasg:client-side tmp lob] - 第1张") 转到底部 |
![ORA-00600 [kollasg:client-side tmp lob] - 第2张](http://www.2cto.com/uploadfile/2014/1013/20141013092252743.gif "ORA-00600 [kollasg:client-side tmp lob] - 第2张"){kind=small} |
|
In this Document
APPLIES TO:Oracle Database – Enterprise Edition – Version 11.1.0.6 and later SYMPTOMSAn 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]. CAUSEThe 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. SOLUTIONInitialize the CLOB field/column with empty_clob(), either on INSERT or after the row is inserted via an UPDATE. |
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。