ORA-22927: invalid LOB locator specified



ORA-22927: 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.

Action: For (1), initialize the LOB locator by selecting
into the locator variable or by setting the LOB locator to
empty. For (2) and (3), 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

NNF-04000: File succesfully converted

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  


TNS-04233: Trace Assistant WARNING: Going beyond Packet length

1 Answers  


ORA-24129: table name string does not start with string prefix

1 Answers  


RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command

1 Answers  






TNS-01401: Class: string

1 Answers  


ORA-23501: refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0

1 Answers  


ORA-13419: cannot perform mosaick operation on the specified table column

1 Answers  


ORA-26575: remote database does not support replication parallel propagation

1 Answers  


NZE-29029: SSL handshake already completed

1 Answers  


KUP-02000: wrong message file version (msg number not found)

1 Answers  


ORA-23454: flavor string not defined for object group "string"."string"

1 Answers  


Categories