GeekInterview.com
Series: Subject: Topic:
Question: 267 of 290

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
Raghavendra

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

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

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

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.

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.