Re: Mutating Table Error (with a twist)

From: Robert Goodwin <robert.goodwin_at_msfc.nasa.gov>
Date: Thu, 20 Aug 1998 15:01:44 -0500
Message-ID: <6rhvba$gfn$1@hammer.msfc.nasa.gov>

This is sort of what I was suspecting, but I was hoping someone could verify it for me. We have split the trigger into two separate triggers, and that does work, but I was hoping to find a way to avoid this. Thanks for your help.

Robert

Roland Svensson wrote in message <35dc659b.9173310_at_nntpserver.swip.net>...
>It looks like Oracle decides about possible 'mutating tables' for this
>trigger at compiletime and not at runtime. Since t1_trigger is an
>update trigger and it modifies primary key, T2 migth be a mutating or
>constraining table for this trigger. So, it may not be invoked when
>T2 is mutating. I added av few 'put_line' to t1_trigger and I don't
>think any single line of t1_trigger is ever executed.
>
>Would this be different on pre 7.3?
>
>Possible workaround: split your trigger in two, one for update
>and the other for insert.
>
>--
>Regards,
>Roland
Received on Thu Aug 20 1998 - 15:01:44 CDT