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