Update failed with ORA-01403: no data found using dml handler-Oracle Streams
Insert is working fine and update is not working. It throws an error
ORA-01403: no data found
ORA-06512: at "SYS.LCR$_ROW_RECORD", line 419
SQL> desc scott.bonus
Name Null? Type
----------------------------------------- --------
----------------------------
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
SAL NUMBER
COMM NUMBER
Target
======
SQL> desc scott.bonus
Name Null? Type
----------------------------------------- --------
----------------------------
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
SAL NUMBER
COMM NUMBER
ID DATE
SQL>
Tried to work on this dml handler with respective to note 265867.1.
Insert is working fine like using
lcr.ADD_COLUMN('new','ID',SYS.AnyData.ConvertDate(sysdate));
and update and delete is not working.