In this chapter, you will learn about
• Handling errors
• Built-in exceptions
In Chapter 1, “PL/SQL Concepts,” you encountered two types of errors that can be found in a program: compilation errors and runtime errors. You will recall that a special section in a PL/SQL block handles runtime errors. This is called the exception-handling section, and in it, runtime errors are called exceptions. The exception-handling section allows programmers to specify what actions should be taken when a specific exception occurs.
PL/SQL has two types of exceptions: built-in and user-defined. In this chapter, you will learn how to handle certain kinds of runtime errors with the help of built-in ...