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

LSX-00284: duplicate constraint name "~S"

1 Answers  


ORA-22805: cannot insert NULL object into object tables or nested tables

1 Answers  


ORA-29967: Cannot drop an operator binding with dependent objects

1 Answers  


ORA-03123: operation would block

1 Answers  


DRG-12432: configuration file string not found or unreadable

1 Answers  






ORA-14293: Number of partitioning columns does not match number of subpartitioning columns

1 Answers  


RMAN-08162: executing Memory Script

1 Answers  


RMAN-06004: ORACLE error from recovery catalog database: string

1 Answers  


ORA-25130: cannot modify primary key - primary key not defined for table

1 Answers  


ORA-12502: TNS:listener received no CONNECT_DATA from client

1 Answers  


DRG-13102: index partition name must be specified

1 Answers  


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

0 Answers   IBM,


Categories