Last updated on JUNE 09, 2015
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2 to 12.1]
Information in this document applies to any platform.
When attempting to access LOBs, the following error occurs as reported in the alert log:
The trace file shows characteristics like:
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x2509fee58 1139 package body SYS.DBMS_LOB
0x24faaecf8 45 package body SAP1.DB_BLOB
0x24d683fe0 1 anonymous block
----- Call Stack Trace -----
... kcbgcur ktspgsb3 ktsplbfmb ktsplbrecl ktspgsp_main kdlgsp_init kdl_write1 kdlf_write koklwrite1 koklwrite kkxlwra kkxlbwra ...
For this situation, the current sql indicates the use of a temporary table and the PL/SQL stack shows the LOB involvement.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms