Re: how to avoid 04091

From: Christian Bär <Christian_at_Baer.Net>
Date: 2000/07/31
Message-ID: <20000731.21335379@mis.configured.host>#1/1

Are you updating, inseeting or selecting on the table on which the trigger works?

It would be helpful to see the trigger!

Christian Baer

>>>>>>>>>>>>>>>>>> Urspr ngliche Nachricht <<<<<<<<<<<<<<<<<<

Am 31.07.00, 20:16:16, schrieb luio <lctNOlcSPAM_at_hotmail.com.invalid>

zum Thema how to avoid 04091:

> ORA-04091 table string.string is mutating, trigger/function may
> not see it

> Cause: 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.

> Action: Rewrite the trigger (or function) so it does not read
> that table.

> I write the trigger after delete or before delete, but non of
> them works, how can i avoid this problem?

> -----------------------------------------------------------

> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
Received on Mon Jul 31 2000 - 00:00:00 CDT