how to avoid 04091

From: luio <lctNOlcSPAM_at_hotmail.com.invalid>
Date: 2000/07/31
Message-ID: <0af13808.48b89eac@usw-ex0104-026.remarq.com>#1/1

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