Re: ora-04091, updating same table in trigger
Date: Tue, 21 Apr 2009 16:57:47 -0700
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.
Certifiable Oracle DBA and Part Time Perl Evangelist