Re: How to audit the execution of a proc

Hi,

Your error ORA-2068 is to do with losing a remote connection to another database via a database link. Also your error text is cut short after the 2068 - first step would be to print out the full error stack. You could write a simple logging procedure in PL/SQL and write errors generated in exception clauses to a trace file for later logging if you want to add more details. The error messages you print below look reasonably structured. have a look at the line numbers in the code of the packages mentioned first and that should give you a clue as to why its failing.

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.