i have a table with values like 1,2,3.... (primary key)
if i delete a row eg.4,
i need my trigger to update the values 5 to 4,6 to 5, 7 to 6,.. like that, after deleting 4.
pls help me...
my table ABC with QNO as primary key.
my trigger
create or replace trigger t1 after delete on abc
referencing old as orow
for each row
declare
begin
update abc set qno=qno-1 where qno>:orow.qno;
end;
Trigger Created
but when i exec the command
delete abc where qno=3;
i get the error msg
delete qb1 where qno=2
*
ERROR at line 1:
ORA-04091: table RECCSE.ABC is mutating, trigger/function may not see it
ORA-06512: at "RECCSE.T1", line 4
ORA-04088: error during execution of trigger 'RECCSE.T1'