Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How can I avoid a recursive trigger?

How can I avoid a recursive trigger?

From: Ovind Osengen <oeo_at_rocketmail.com>
Date: Wed, 21 Feb 2001 18:42:07 +0100
Message-ID: <970ulg$5im$1@oslo-nntp.eunet.no>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US