Error management in Oracle PL/SQL should be part of your application design and should follow a standard process for handling and raising errors. The good news is that you do not have to design and code your error management system yourself because Steven Feuerstein has done all the work for you.

During the seminar that I attended a couple of weeks ago, Steven announced the early release of a new product called the Quest Error Manager or QEM for short.

So, what is QEM? From the product documentation:

QEM is a framework that will help you standardize the management of errors in Oracle PL/SQL-based applications. It consists of the q$error_manager package and several underlying tables that store information about errors that occur in an application.

Moreover, QEM offers a single package to help you trace the execution of your application. The basic features are as follows:

• Write trace information out to the q$log table or to the DBMS_OUTPUT buffer.
• Selectively turn on and off tracing through calls to the q$error_manager procedures.
• Trace execution of code by a context string, and then also include strings, numbers, dates or Boolean values.

The Quest Error Manager is a freeware product and is not supported by Quest Software. You can download it as a zip file from oracleplsqlprogramming.com/downloads/qem.zip.

Lastly, I suggest you read Steven’s PowerPoint presentation Making the Most of PL/SQL Error Management Features. If you do not have Microsoft PowerPoint, you can still read the document from within your browser on scribd.

Related articles:

• How to find where an error was raised in PL/SQL
• Oracle Identity Management Webcast
• Little known way to get the error message in PL/SQL
• Rousing Entertainment With the Guru of Oracle PL/SQL
• Two Oracle PL/SQL Features You Probably Don’t Know About

---

Tagged pl/sql | Comments Closed | Trackbacks Closed