Re: Question: Mutation in Statement Triggers
From: Insighters <insighters_at_aol.com>
Date: 1995/06/20
Message-ID: <3s6o11$sv7_at_newsbf02.news.aol.com>#1/1
Date: 1995/06/20
Message-ID: <3s6o11$sv7_at_newsbf02.news.aol.com>#1/1
Your trigger 'T' is firing via a statement trigger - it's o.k for it to reference a mutating table in this instance. When trigger 'R' which is on table 'A' fires for each row -a mutating table can no longer be referenced. Even though the refernce is occuring in trigger 'T' - it was fired and is connected to the completion of trigger 'R' which is a row level trigger.
Possible solutions:
Use exception handling in trigger 'T' or possibly you could build a temporary table for your query in trigger 'T'. Good Luck.. Received on Tue Jun 20 1995 - 00:00:00 CEST