ORA-22927: invalid LOB locator specified
- 1 Answers
- 2710 Views
- I also Faced
- E-Mail Answers
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 |
ORA-08465: input mask contains more than 32 characters
DRG-11851: Cache Related Warning
IMP-00085: multiple input files specified for unbounded export file
TNS-00142: Community mismatch in TNSNAV.ORA
NNL-00243: Processing of modification requests is now enabled
PLS-00167: keyword BULK is used in a wrong context
ORA-16624: broker protocol version mismatch detected
RMAN-08055: media recovery complete
ORA-10617: Cannot create rollback segment in dictionary managed tablespace
TNS-01184: Listener rejected registration or update of service handler "string"
ORA-09961: Unable to restore termination signal handler
ORA-30487: ORDER BY not allowed here
Oracle Errors 
