Home » SQL & PL/SQL » SQL & PL/SQL » Re: Mutating Trigger...More thoughts
Re: Mutating Trigger...More thoughts [message #36480] Thu, 29 November 2001 06:54
Stefan Schubert
Messages: 2
Registered: November 2001
Junior Member
I have a similiar problem but what wonders me is that it even occurs when I delete the FKs from B to A.

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

Previous Topic: How to Insert a Recordset object using stored procedures.
Next Topic: Compare dates
Goto Forum:

Current Time: Sat May 18 14:49:44 CDT 2024