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...

Cheers

Stefan

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


Current Time: Tue Aug 11 14:45:12 CDT 2020