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]
