Chapter 10 Exceptions

Lab 10.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) C If an exception is defined in the inner block, it can be raised in the inner block only. The outer block is not included in the scope of such an exception.
A2:
Questions Answers Comments
2) B Once an exception has been raised in the inner block and handled in the outer block, the control is passed to the enclosing environment.
A3:
Questions Answers Comments
3) B Once an exception occurs in the outer block, PL/SQL tries to find its handler in the outer block. PL/SQL will never search the inner block for the exception handler when the exception occurs in the outer block.
A4:
Questions Answers Comments
4) B In order to define an exception inside the body ...

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.