CHAPTER 5Error Management

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

Compilation errors

Run-time ...

Get Oracle Database 11g PL/SQL Programming now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.