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:

> 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-l
Received on Tue Apr 21 2009 - 18:57:47 CDT

Original text of this message