Oracle® PL/SQL® Interactive Workbook, Second Edition By Benjamin Rosenzweig, Elena Silvestrova
Table of Contents
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.