Re: ora-04091, updating same table in trigger
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 21 Apr 2009 16:57:47 -0700
Message-ID: <bf46380904211657i5821faa6q1181a27f6495d19b_at_mail.gmail.com>
On Mon, Apr 20, 2009 at 7:28 AM, Harvinder Singh <Harvinder_Singh_at_picis.com>wrote:
Date: Tue, 21 Apr 2009 16:57:47 -0700
Message-ID: <bf46380904211657i5821faa6q1181a27f6495d19b_at_mail.gmail.com>
On Mon, Apr 20, 2009 at 7:28 AM, Harvinder Singh <Harvinder_Singh_at_picis.com>wrote:
> Currently insert into a table is failing with error ora-04091 and it
> ...
> How can we fix this issue, Is there any workaround so that we can update
> the same table in the trigger?
>
Here's one way to do it: http://asktom.oracle.com/tkyte/Mutate/
I've used this for demonstration purposes.
The demonstration being yet one more reason why denormalizing is bad.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 21 2009 - 18:57:47 CDT