Lab 11.1 RAISE_APPLICATION_ERROR

Lab Objective

After this Lab, you will be able to:

✓ Use RAISE_APPLICATION_ERROR

RAISE_APPLICATION_ERROR is a special built-in procedure provided by Oracle. This procedure allows programmers to create meaningful error messages for a specific application. The RAISE_APLICATION_ERROR procedure works with user-defined exceptions. The syntax of the RAISE_APPLICATION_ERROR is

RAISE_APPLICATION_ERROR(error_number, error_message);

or

RAISE_APPLICATION_ERROR(error_number, error_message, 
   keep_errors);

As you can see, there are two forms of the RAISE_APPLICATION_ERROR procedure. The first form contains only two parameters: error_number and error_ message. The error_number is a number of the error that a programmer ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial