Re: Trigger problem @ Execution

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Mon, 19 Nov 2001 07:08:09 +0100
Message-ID: <pd8hvtkoo6m2g8qrcb2470ntv2u1uvmmt7@4ax.com>

On 18 Nov 2001 21:06:54 -0800, david_at_ionideainteractive.com (David Jeyathilak) wrote:

>Hi,
>When I compile a trigger, it shows no errors. But at the time of
>execution it throws up the following error message. What could be
>wrong?
>
>ORA-04091: table dbname.table1 is mutating, trigger/function may not
>see it
>ORA-04088: error during execution of trigger 'dbname.trgA'
>
>regards,
>David.

Please read
http://govt.oracle.com/~tkyte/Mutate/index.html

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 19 2001 - 00:08:09 CST