Re: URGENT - Trigger error

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 27 Oct 1999 08:40:55 -0400
Message-ID: <wPIWOIeu9A0j45hB+lO1FKsDheBI@4ax.com>

A copy of this was sent to "David Maya" <maya_at_grn.es> (if that email address didn't require changing) On Tue, 26 Oct 1999 22:36:14 +0200, you wrote:

>Hello :
>
>I'm using Oracle 8i, and I've the next problem:
>
>I've two tables TABLE1 TABLE2
>TABLE1 have one PK, that is the FK of TABLE2
>
>I've an AFTER UPDATE TRIGGER in TABLE1, that inserts in TABLE2 the actual
>updated record from TABLE1. OK by now.
>
>BUT when I really Update a record in TABLE1, Oracle gives me the next error
>:
>
> SQL ERROR, TABLE1 IS MUTANT
>

see the short paper "Avoiding Mutating Tables (HOWTO)" at the web site in my signature below.

>What can I do ??
>
>Thank you in advance
>
>David
>
>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Oct 27 1999 - 07:40:55 CDT