Chapter 7. Error Handling and Built-In Exceptions


Oracle® PL/SQL® Interactive Workbook, Second Edition
By Benjamin Rosenzweig, Elena Silvestrova
Table of Contents

Chapter Objectives

In this Chapter, you will learn about:

  • Handling Errors

  • Built-In Exceptions

In Chapter 2, you encountered two types of errors that can be found in a program: compilation errors and runtime errors. You will recall that there is a special section in a PL/SQL block that handles runtime errors. This section is called the exception-handling section, and in it, runtime errors are referred to as exceptions. The exception-handling section allows programmers to specify what actions should be taken when a specific exception occurs.

In PL/SQL, there are two types of exceptions: built-in exceptions and user-defined exceptions. In this chapter, you will learn how you can handle certain kinds of runtime errors with the help of built-in exceptions. User-defined exceptions are discussed in Chapters 10 and 11.


    Oracle PL. SQL Interactive Workbook
    Oracle PL/SQL Interactive Workbook (2nd Edition)
    ISBN: 0130473200
    EAN: 2147483647
    Year: 2002
    Pages: 146 © 2008-2017.
    If you may any questions please contact us: