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 |
IMG-00831: boundary queue size exceeds expected size
NNL-00542: restart [<server_list>] : restart one or more Names servers
DRG-50924: PL/SQL inside PL/SQL not supported
ORA-23341: user function required
ORA-00438: %s Option not installed
LFI-00149: Error on destroying hash table in function string
LFI-00106: Path object holds more than one path.
ORA-02488: Error encountered when accessing file [string] for trace conversion
SQL*Loader-00555: unrecognized processing option
ORA-00082: memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
ORA-29963: missing BINDING keyword
LPX-00125: duplicate entity "~S" (ignored)