How can I get off a error message oracle form A0001 ask me to save the record when I change a record to other ?

Shital Mistry

• Aug 11th, 2012

If it an oracle error you are trying to trap than I would use ON-ERROR trigger on specific block, use built ins DBMS_ERROR_CODE, DBMS_ERROR_TEXT to trap the error.

Shital Mistry

• Aug 6th, 2012

I would write ON_MESSAGE trigger on block level, trap particular message with built ins MESSAGE_CODE, MESSAGE_TEXT and handle the error...

Answer Question  Select Best Answer