Message error

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

Questions by nghiavt2004

Showing Answers 1 - 9 of 9 Answers

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...

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions