Re: Exception handling inpl/sql

Hi Steve

If i understand you right you are adding an exception block to each procedure and calling a local procedure to handle the exception. It is a bit hard to comment without knowing the complexity of the code in your procedures but if you want some sort of controlled exception handling you would need to review the existing code and add blocks with exception handlers wherever an "interesting" exception could occur. i.e if you have 10 SQL's or other bits of code that can cause an exception and one exception block and a standard procedure to handle how would you know which piece of SQL caused the exception?

Just a suggestion but maybe in tandem with your "global" exception handlers you could add some "trace" calls to write "flow" to a file. Use a simple package using utl_file and record procedure/function and line number - Tom Kyte has some code on his site to do this. Adding simple trace shouldn't upset your existing code.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.