Oracle® PL/SQL® Interactive Workbook, Second Edition

Lab 10.3 Exception Propagation

Lab Objectives After this Lab, you will be able to: ✓ Understand How Exceptions Propagate ✓ Re-raise Exceptions

You already have seen how different types of exceptions are raised when a runtime error occurs in the executable portion of the PL/SQL block. However, a runtime error may occur in the declaration section of the block or in the exception-handling section of the block. The rules that govern how exceptions are raised in these situations are referred to as exception propagation.

Consider the first case: A runtime error occurred in the executable section of the PL/SQL block. This case should be treated as a review because the examples that you have seen earlier in this chapter show how an exception is raised ...