Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Triggers recursive call
Hi to all,
Does anybody know how setup the database to avoid any trigger recursive call?
Look at this dummy example: Trigger is "statement" related type trigger (not of "for each row" type). If I run the below using "for each row" clause I get mutating error. create or replace trigger tr_booking after update on booking declare cont number; beginReceived on Wed Nov 22 2000 - 18:36:29 CST
...
update booking set col1 = col1 + 10 where col2 = 'A';
...
end; /