O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, 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 10 Exceptions: Advanced Concepts

CHAPTER OBJECTIVES

In this chapter, you will learn about

• RAISE_APPLICATION_ERROR

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

Lab 10.1 RAISE_APPLICATION_ERROR

LAB OBJECTIVE ...

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