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

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


Current Time: Mon Mar 30 00:19:08 CDT 2020