GeekInterview.com
Series: Subject: Topic:
Question: 1 of 165

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 ?
Asked by: nghiavt2004 | Member Since Dec-2011 | Asked on: Dec 17th, 2011

View all questions by nghiavt2004

Showing Answers 1 - 3 of 3 Answers

I suggest you make use of triggers to take control over the default message.

You can try triggers such as ON-CLEAR-DETAILS trigger.

  
Login to rate this answer.
Shital Mistry

Answered On : 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...

  
Login to rate this answer.
Shital Mistry

Answered On : 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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.