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]