Well I think I have a solution. I already have a PLSQL package which will add instrumentation to all other existing packages, procedures and functions. In a much earlier version of this I added logging and a call to dbms_utility.format_error_stack to every existing error handler. However, the logic for this was a bit complicated since an exception handler strings may not always be very consistent. Looks like I will need to revisit this code and perhaps bring it back to life. That will tell me where this little rascal ORA- is occurring.
- Ethan
On 3/2/06, Baumgartel, Paul <paul.baumgartel@(protected)> wrote: -- http://www.freelists.org/webpage/oracle-l