Re: Trigger: Update the table which fires the trigger?

From: gazzag <>
Date: Thu, 14 Feb 2008 07:03:51 -0800 (PST)
Message-ID: <>

On 14 Feb, 14:56, Caja <> wrote:
> Hello,
> I created an
> BEFORE UPDATE OF column list ON table FOR EACH ROW
> trigger in an 10g instance.
> In the body I am trying to update an other column of the same table
> which is fireing the trigger.
> The trigger is compiled an valid. When the trigger is fired I got
> ORA-04091: "...A trigger (or a user defined PL/SQL function that is
> referenced in this statement) attempted to look at (or modify) a table
> that was in the middle of being modified by the statement which fired
> it."
> This I understand but I want to do the extra Update as well. Is there
> a way?
> A hint would be highly appreciated. Thanks!
> Carsten

HTH -g Received on Thu Feb 14 2008 - 09:03:51 CST

Original text of this message