DELETE Trigger not Firing, Help ASAP
I have a delete trigger that will not fire. I am attempting to use the Trigger to prevent deletion of specific rows. If I create a copy of the table and add the trigger to it, the trigger fires correctly.
The reason I know the trigger is not firing because I tried this.
CREATE OR REPLACE TRIGGER t_RT_Group_BD
AFTER DELETE ON RT_GROUP
FOR EACH ROW
BEGIN
RAISE_APPLICATION_ERROR(-20115,'rrr');
END;
And the delete still succeeds.
However update triggers will prevent updating of certain rows.
I am using ORACLE 8.1.6.1.0
P.S. The table has gone through several columns adds, since its initial creation.