Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ignore ORA-02292

442925Sep 27 2006 — edited Sep 28 2006
I'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;
/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2006
Added on Sep 27 2006
7 comments
2,044 views