Raghavendra

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

g_sidhu

 Profile 

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

SARANYA

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

Ashutosh

• 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