Series: Subject: Topic:
Question: 469 of 492

What is Raise_application_error ?

 Raise_application_error  is  a  procedure  of  package  DBMS_STANDARD which allows  to  issue an user_defined error messages from stored sub-program or database trigger.
Asked by: Interview Candidate | Asked on: Sep 9th, 2004
Showing Answers 1 - 4 of 4 Answers

Answered On : Nov 15th, 2006

Raise_application_error is used to create your own error messages which can be more descriptive than named exceptions.Syntax is:-Raise_application_error (error_number,error_messages);where error_number is between -20000 to -20999..

Yes  3 Users have rated as useful.
Login to rate this answer.

Answered On : Jan 31st, 2008

You can use this procedure to issue user-defined error messages from stored subprograms.You can report errors to your application and avoid returning unhandled exceptions.Syntax: raise_application_error (error_number,message[, {TRUE | FALSE}]);

Login to rate this answer.

Answered On : Jul 25th, 2011

I know that the error no in raise_application_error are non standard but tell me on what basis we are giving those numbers? is that simply a number or it some implicit meaning ?

Login to rate this answer.

Answered On : Oct 8th, 2012

Their classes of errors and diff. errors are divided among these classes simply because of ease in classification,
For defining errors and error message with raise_application_error procedure by users the class of error number ranges from 20000 to 20999.
That is only numbers from this interval can be used to defining your own error code

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.



twitter fb Linkedin GPlus RSS


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.