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.


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 10g DBMS_UTILITY.FORMAT_CALL_STACK. In this chapter we will do the following: ...

Get Expert Oracle PL/SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.