Chapter 11 Exceptions: Advanced Concepts

Lab 11.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) C RAISE_APPLICATION_ERROR associates an error number with an error text. Therefore, when working with the RAISE_APPLICATION_ERROR there is no need to create an exception name.
A2:
Questions Answers Comments
2) C RAISE_APPLICTION_ERROR has two required parameters, error_number and error_text. The keep_error is an optional parameter that is usually omitted.
A3:
Questions Answers Comments
3) A Generally, Oracle associates negative numbers with runtime errors. For user-defined exceptions, the range of such numbers is from −20,000 to −20,999.
A4:
Questions Answers Comments
4) A When the RAISE_APPLICATION_ERROR procedure is used, control ...

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