Home » SQL & PL/SQL » SQL & PL/SQL » Re: Mutating Trigger...More thoughts
Re: Mutating Trigger...More thoughts [message #36856] Thu, 27 December 2001 21:35
Stefan Schubert
Messages: 2
Registered: November 2001
Junior Member
Hi Susan,

thanks for your answer! I have been on vacation meanwhile so it took me a while to come back to this point.

I could spare Tom's solution. I understand the problem caused by the constraining table but what I didn't understand was that even when disabling the foreign key constraints I got the same error. However dropping the foreign keys worked.

So for this problem oracle seems to make no difference wether a constraint is disabled or not which I belive is a good idea, however you need to know that when trying to debug the mutating problem by disabling constraints...



Previous Topic: Table's Script
Next Topic: Re: Stored Procedure Problems
Goto Forum:

Current Time: Sat May 25 15:36:34 CDT 2024