ORA-22927: invalid LOB locator specified
- 1 Answers
- 2720 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-01212: MAXLOGMEMBERS may not exceed string
ORA-15124: ASM file name 'string' contains an invalid alias name
EXP-00036: Object number non-existent in dictionary
ORA-00721: changes by release string cannot be used by release string
ORA-02177: Missing required group number
ORA-28102: policy does not exist
ORA-14167: only one subpartition may be moved
TNS-04019: Starting Oracle Connection Manager instance string. Please wait...
SQL*Loader-00959: Error shipping buffer across 2-task
RMAN-08054: starting media recovery
NZE-29007: Bad Clear Key Length when using SSL 2.0
IMP-00089: Fine grain policy "string" not recreated on table/view "string"
Oracle Errors 
