Re: ora-04091, updating same table in trigger

From: Jared Still <>
Date: Tue, 21 Apr 2009 16:57:47 -0700
Message-ID: <>

On Mon, Apr 20, 2009 at 7:28 AM, Harvinder Singh <>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:

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

Received on Tue Apr 21 2009 - 18:57:47 CDT

Original text of this message