The trick is where to put that exception handler. ...

2010-01-23T11:58:58.832+11:00

The trick is where to put that exception handler. Say you have have the sql in p1, which is called by p2 which is called by p3, and an exception handler in p2 is catching your exception.

If you put your handler in p3, it won't be triggered as the exception is caught at a lower level. If you put it in p1, that still won't tell you about p2 (unless you add in FORMAT_CALL_STACK).

That said, I like those procedures and SERVERERROR triggers are also great for error logging and back tracking.

Hi! Maybe you can use: exception when others t...

2010-01-23T07:23:44.342+11:00

Hi!

Maybe you can use:
exception
when others then dbms_output.put_line(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE||DBMS_UTILITY.format_call_stack');
end;

You will find a lot of information in this way...even answer to your question.
;-)
Damir Vadas
http://damir-vadas.blogspot.com

Comments on Sydney Oracle Lab: Who caught my error ?

The trick is where to put that exception handler. ...

Hi! Maybe you can use: exception when others t...