RAISE_APPLICATION_ERROR in oracle

Published on August 24 2015 by LakshmiSaahul,Dhana Royal

RAISE_APPLICATION_ERROR?

The RAISE_APPLICATION_ERROR is a procedure defined by Oracle that allows the developer to raise an exception and associate an error number and message with the procedure other than just Oracle errors. Raising an Application Error With raise_application_error

num_tables NUMBER;

BEGIN

SELECT COUNT(*) INTO num_tables FROM USER_TABLES;

IF num_tables < 1000 THEN

/* Issue your own error code (ORA-20101) with your own error message.

Note that you do not need to qualify raise_application_error with

DBMS_STANDARD */

raise_application_error(-20101, 'Expecting at least 1000 tables');

ELSE

NULL; -- Do the rest of the processing (for the non-error case).

END IF;

END;

The procedure RAISE_APPLICATION_ERROR lets you issue user-defined ORA- error messages from stored subprograms. That way, you can report errors to your application and avoid returning unhandled exceptions.

pragma exception_init?

It tells the compiler to associate an exception with an oracle error. To get an error message of a specific oracle error.

Ex: pragma exception_init(exception name, oracle error number)

Advertising