Triggers and mutating tables

I have 3 tables - A, B and C. A and B are in a parent/child relationship with A being the parent. C contains summary rows of data and is updated by triggers whenever A and B are updated.

I would like to set up triggers to do the following:

1. When a row is deleted from A, delete corresponding entries in B and C.
2. When a row is deleted from B, delete corresponding entries in C.

The problem is that when I delete from A, the triggers fail because C is considered to be mutating, since the delete on A triggered a delete on B which triggered a delete on C.

Is there any way to tell Oracle to ignore mutating table problems, and put the appropriate error checks in my triggers ?

Thanks,

Pete
pchiccarino_at_usaNOSPAM.net Received on Thu Nov 11 1999 - 11:38:47 CST