O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required