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

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