Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How can I avoid a recursive trigger?
To deal with the ORA-04091 Mutating table error, I decomposed a trigger into 3 triggers, i.e. before statement, before each row and after statement triggers in addition to a package for trigger state. This method is described by several authors.
However I need an insert or update or delete trigger, this is less described in the litterature. E.g. when an insert occurs, a field in the triggering table is updated by the trigger, this value depends on other records in the same table. The update in the after statement trigger fires another update trigger that results in recursion ( ORA-00036 ), however this is not intended. What is a good approach to avoid this? Any links?
Thanks
Ovind
Received on Wed Feb 21 2001 - 11:42:07 CST