ORA-04091 trigger mutation

From: yamaha <r1_cycleracer_at_yahoo.com>
Date: 22 Mar 2002 08:09:54 -0800
Message-ID: <3ab43dae.0203220809.61f80009@posting.google.com>

Here is my trigger:

create or replace trigger test

   before
   update of status
   on int_audiences_1102
   for each row
   when (new.status = 3)   

   begin
    delete activity_aud_group_map where audience_member_id = :new.aud_id

         and activity_aud_group_id in
        (select activity_aud_group_id from interaction_aud_groups where
         interaction_id = 1102);

    delete int_aud_list_1102 where aud_id = :new.aud_id;     delete int_audiences_1102 where aud_id = :new.aud_id;

    delete int_tag_value_1102 where aud_id = :new.aud_id;   

   end;

I get the mutate error because of this line :

delete int_audiences_1102 where aud_id = :new.aud_id;

what can I do to fix this...thanks Received on Fri Mar 22 2002 - 10:09:54 CST