O'Reilly logo

Oracle Database 11g PL/SQL Programming by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required