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.

Showing Answers 1 - 4 of 4 Answers


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


  • 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}]);

  Was this answer useful?  Yes


  • 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 ?

  Was this answer useful?  Yes


  • 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

  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