| 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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
