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

On 14 Feb, 14:56, Caja <carsten.jac..._at_gmail.com> 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

http://asktom.oracle.com/tkyte/Mutate/index.html

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