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 ...
Get Oracle Database 10g PL/SQL Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
