O'Reilly logo

Oracle Database 10g PL/SQL Programming by Michael McLaughlin, Ron Hardman, Scott Urman

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 7Error Handling

Any well-written program must have the capability to handle errors intelligently and recover from them if possible. PL/SQL implements error handling with exceptions and exception handlers. Exceptions can be associated with Oracle errors or with your own user-defined errors. In this chapter, we will discuss the syntax of exceptions and exception handlers, how exceptions are raised and handled, and the rules of exception propagation. The chapter closes with guidelines on using exceptions.

What Is an Exception?

In Chapter 1 we discussed how PL/SQL is based on the Ada language. One of the features of Ada that is incorporated into PL/SQL is the exception mechanism. By using exceptions and exception handlers, you can make your ...

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