Database Administration (MOSC)

MOSC Banner

Update failed with ORA-01403: no data found using dml handler-Oracle Streams

edited Nov 28, 2008 9:33AM in Database Administration (MOSC) 1 commentAnswered
 When I tried to work on the note 265867.1.

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center