Re: Mutating Trigger...More thoughts [message #36480] |
Thu, 29 November 2001 06:54 |
Stefan Schubert
Messages: 2 Registered: November 2001
|
Junior Member |
|
|
Hi,
I have a similiar problem but what wonders me is that it even occurs when I delete the FKs from B to A.
Szenario:
after delete trigger on table A for each row
Trigger starts a stored procedure
the stored procedure drops some columns
in tabe B and open a cursor afterwards
to perform some postwork (updates).
Cursor closes and procedure commits.
Yes B has FKs back to A, the problem (mutationg table B , trigger may not see it...) occurs as well when droping the FK constraints.
What's wrong here?
-- Stefan
----------------------------------------------------------------------
|
|
|