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.



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net