Ignore ORA-02292
442925Sep 27 2006 — edited Sep 28 2006I'm trying to write a trigger that will allow me to ignore an ORA-02292 but allow all others to be raised. Ex:
CREATE OR REPLACE TRIGGER MyTrigger
AFTER DELETE ON MyTable
FOR EACH ROW
DECLARE ERROR_CODE NUMBER;
BEGIN
DELETE FROM MyTable ...;
EXCEPTION
WHEN OTHERS THEN
ERROR_CODE := SQLCODE:
IF ERROR_CODE = -02292 THEN
NULL
END IF;
END;
/