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.
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:
- When a row is deleted from A, delete corresponding entries in B and C.
- 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