Chapter 11. Exceptions: Advanced Concepts

Chapter Objectives

In this Chapter, you will learn about:

✓ RAISE_APPLICATION_ERROR

✓ EXCEPTION_INIT Pragma

✓ SQLCODE and SQLERRM

In Chapters 7 and 10, you encountered the concept of error handling, built-in exceptions, and user-defined exceptions. You also learned about the scope of an exception, and how to re-raise an exception.

In this chapter you will conclude your exploration of error handling and exceptions with a study of advanced topics. After working through this chapter, you will be able to associate an error number with an error message. You also will be able to trap a runtime error having an Oracle error number but no name by which it can be referenced.

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