ORA-22281: cannot perform operation with an updated locator



ORA-22281: cannot perform operation with an updated locator..

Answer / guest

Cause: The input locator has buffering enabled and was used
to update the LOB value through the LOB buffering subsystem.
The modified buffer has not been flushed since the write
that was performed by the the input locator; thus, the input
locator is considered an updated locator. Updated locators
cannot be the source of a copy operation. Only one locator
per LOB may be used to modify the LOB value through the LOB
buffering subsystem.

Action: Depending on whether the modifications made through
the input locator to the LOB buffering subsystem should be
written to the server, either flush the buffer to write the
modifications, or, disable buffering on the locator to
discard the modifications. Then, reissue the command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25151: Rollback Segment cannot be created in this tablespace

1 Answers  


ORA-29285: file write error

1 Answers  


PCB-00100: Unable to reopen temporary file string

1 Answers  


ORA-07485: scg_get_inst: cannot open instance number lock.

1 Answers  


DRG-13003: preference string cannot be used as a sub lexer

1 Answers  






LSX-00215: value "~1S" whose total digits exceeds ~2d

1 Answers  


ORA-27508: IPC error sending a message

1 Answers  


ORA-27194: skgfdvcmd: sbtcommand returned error

1 Answers  


NNF-00540: Failed to insert name: string

1 Answers  


PCC-02304: invalid declaration of C function

1 Answers  


ORA-12920: database is already in force logging mode

1 Answers  


ORA-09284: sllfop: cannot allocate read buffer

1 Answers  


Categories