trigger - DELETE Cascade Trigger for Parent Table not working

CREATE OR REPLACE TRIGGER Dept_del_cascade
AFTER DELETE ON Dept
FOR EACH ROW
BEGIN
DELETE FROM Emp
WHERE Emp.Deptno = :old.Deptno;
END;
/

SQL> delete from dept where deptno = 40;
delete from dept where deptno = 40
*
ERROR at line 1:
ORA-02292: integrity constraint (SCOTT.FK_DEPTNO) violated - child record found


why does'nt the trigger take care of this problem?

try givin before delete!

before gives a mutating table error

Since it's an after trigger, the RI constraint is evaluated first...
Why don't you have the foreign key as a cascading delete instead of
trying to put this in a trigger ???

Gregg

Quote:

---

Originally posted by varshanswamy
before gives a mutating table error

---

No, it doesn't. It can't. It won't.