Lab 7.2 Built-In Exceptions

Lab Objectives

After this Lab, you will be able to:

✓ Use Built-In Exceptions

As mentioned earlier, a PL/SQL block has the following structure:

DECLARE 
   … 
BEGIN 
   EXECUTABLE STATEMENTS; 
EXCEPTION 
   WHEN EXCEPTION_NAME THEN 
      ERROR-PROCESSING STATEMENTS; 
END;

When an error occurs that raises a built-in exception, the exception is said to be raised implicitly. In other words, if a program breaks an Oracle rule, control is passed to the exception-handling section of the block. At this point, the error-processing statements are executed. It is important for you to realize that after the exception-handling section of the block has executed, the block terminates. Control will not return to the executable section of the block. ...

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