In this chapter, you will learn about
• EXCEPTION_INIT pragma
• SQLCODE and SQLERRM
In Chapters 8 and 9, you encountered the concepts of error handling, built-in exceptions, and user-defined exceptions. You also learned about the scope of an exception and how to reraise an exception.
In this chapter you 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 that has an Oracle error number but no name by which it can be referenced.