records in the Fuseactions table you are trying to delete. Try deleting the
records from Fuseactions by hand to see if you get any constraint
violations.
-----Original Message-----
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]
Sent: Thursday, 06 November, 2003 4:13 PM
To: CF-Talk
Subject: OT: Oracle Trigger
I am creating a trigger in oracle 8i does anyone see anything wrong with
this? It causes this error whn i try to delete from the Circuits table
Error:
Error: ORA-04098: trigger mydb.CIRCUITS_BEF_DEL' is invalid and failed
re-validation
Trigger:
/* Create TRIGGER for Circuits BEFORE DELETE */
CREATE OR REPLACE TRIGGER Circuits_bef_del
BEFORE DELETE
ON Circuits
FOR EACH ROW
BEGIN
DELETE FROM Fuseactions
WHERE Circuit_id = old.Circuit_id
END
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]