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 |
LSX-00284: duplicate constraint name "~S"
ORA-22805: cannot insert NULL object into object tables or nested tables
ORA-29967: Cannot drop an operator binding with dependent objects
ORA-03123: operation would block
DRG-12432: configuration file string not found or unreadable
ORA-14293: Number of partitioning columns does not match number of subpartitioning columns
RMAN-08162: executing Memory Script
RMAN-06004: ORACLE error from recovery catalog database: string
ORA-25130: cannot modify primary key - primary key not defined for table
ORA-12502: TNS:listener received no CONNECT_DATA from client
DRG-13102: index partition name must be specified
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...