ORA-22275: invalid LOB locator specified



ORA-22275: invalid LOB locator specified..

Answer / guest

Cause: There are several causes: (1) the LOB locator was
never initialized; (2) the locator is for a BFILE and the
routine expects a BLOB/CLOB/NCLOB locator; (3) the locator
is for a BLOB/CLOB/NCLOB and the routine expects a BFILE
locator; (4) trying to update the LOB in a trigger body --
LOBs in trigger bodies are read only; (5) the locator is for
a BFILE/BLOB and the routine expects a CLOB/NCLOB locator;
(6) the locator is for a CLOB/NCLOB and the routine expects
a BFILE/BLOB locator;

Action: For (1), initialize the LOB locator by selecting
into the locator variable or by setting the LOB locator to
empty. For (2),(3), (5) and (6)pass the correct type of
locator into the routine. For (4), remove the trigger body
code that updates the LOB value.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39071: Value for string filter is badly formed.

1 Answers  


ORA-10916: TABLESPACE GROUP already specified

1 Answers  


ORA-29342: user string does not exist in the database

1 Answers  


ORA-00390: log string of thread string is being cleared, cannot become current log

1 Answers  


ORA-02794: Client unable to get key for shared memory

1 Answers  






ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

1 Answers  


ORA-29906: indextype string.string does not exist

1 Answers  


PLS-00640: a pipelined function cannot be called from PL/SQL context

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


ORA-12446: Insufficient authorization for administration of policy string

1 Answers  


ORA-28035: Cannot Get Session Key for Authentication

1 Answers  


ORA-24398: connection pool already exists

1 Answers  


Categories