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 |
PLS-00216: NUMBER precision constraint must be in range (1 .. 38)
ORA-19922: there is no parent row with id string and level string
ORA-30334: illegal dimension level name
ORA-33213: (CINSERT06) The target position for MAINTAIN ADD or MAINTAIN MOVE cannot fall in the range of session-only values.
ORA-00307: requested INSTANCE_NUMBER out of range, maximum is string
NZE-28842: Incorrect file permissions
ORA-02302: invalid or missing type name
ORA-01237: cannot extend datafile string
NNL-00270: Current default domain is "string"
ORA-26681: command type not supported
NNF-01007: DCE long strings are not supported
NCR-04007: NCRR: Invalid object handle