trigger question

From: luio <lctNOlcSPAM_at_hotmail.com.invalid>
Date: 2000/08/01
Message-ID: <09003a9e.e7b67c8f@usw-ex0104-028.remarq.com>#1/1

no matter I set it as before or after delete, it will report 04901 error.
how can I void it?
the only condition I used is like
delete from table1 where table1.column1 = :old.cl1; ????

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.

thank you

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