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 |
QSM-01012: SAMPLE clause present in FROM
ORA-13142: invalid PROXIMITY window definition
RMAN-05508: SET NEWNAME TO NEW not allowed (datafile string)
ORA-13461: the interleaving type is not supported
ORA-10661: Invalid option specified
PCC-02433: Invalid host variable and attribute pairing
PROC-00031: Storage device for the cluster registry is too small
RMAN-06137: must have recovery catalog for REPORT SCHEMA AT TIME
LPX-00408: right parenthesis missing in the XSL file
IMG-00546: invalid page number specified
ORA-02785: Invalid shared memory buffer size
ORA-03208: partitioned type must be specified for a non-composite object