Re: Error ORA-04091

From: Michel Cadot <micadot_at_francemel.com>
Date: Thu, 19 Aug 1999 09:10:55 +0200
Message-ID: <7pgan8$25p$1@oceanite.cybercable.fr>

In a trigger you cannot select or modify rows from the table that has fired the trigger.

See the Thomas Kyte site: http://govt.us.oracle.com/~tkyte/ there is a HOWTO on mutating tables....

Luca Cappelletti a écrit dans le message <37c03535.911720_at_proxy>...
>Hi!
>Is there anybody who knows this error?
>I'm calling a stored procedure from an "AFTER INSERT" trigger. The SP
>open a cursor and modifies a lot of records of the same table invoking
>the trigger.
>
>The error code and decription are: "ORA-04091: table MYSCHEMA.MYTABLE
>is mutating, trigger/function may not see it"
>
>Help me!
>Thanks in advance.
>Luca
Received on Thu Aug 19 1999 - 02:10:55 CDT