This chapter covers PL/SQL error management. PL/SQL handles errors in the exception block. You'll find two types of errors in PL/SQL: compilation errors and run-time errors. You discover compilation errors when you run an anonymous block program or attempt to build a stored program unit—a function, procedure, or user-defined object type. Run-time errors are more complex because they have two potential scenarios. Run-time errors raise manageable errors in the execution or exception blocks, but you can't catch run-time errors raised in the declaration block.
You will learn about both types of errors and how to manage them in this chapter. Sections in the chapter are
Exception types and scope