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.

Chapter 3. Debugging PL/SQL Applications

Managing PL/SQL code errors in the database requires planning and organization. You need a simple and consistent approach to the challenge of trapping, tracing, and identifying runtime errors. However, there is a distinct difference between managing errors in runtime code versus database trigger code.

Tip

Oracle has also added a new DBMS_UTILITY.FORMAT_CALL_STACK function to Oracle 10g, which will be covered in this chapter. It allows custom formatting of call stacks.

This chapter stands independent of the other chapters in the book. All of the content in it works in currently supported versions of the Oracle database except the Oracle 10gDBMS_UTILITY.FORMAT_CALL_STACK. In this chapter we will do the following: ...

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