Triggers and mutating tables

From: Pete Chiccarino <chiccarinop_at_firstenergycorp.com>
Date: Thu, 11 Nov 1999 12:38:47 -0500
Message-ID: <382aff71_at_172.16.4.124>



[Quoted] 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.

[Quoted] 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 - 18:38:47 CET

Original text of this message