Home » SQL & PL/SQL » SQL & PL/SQL » get error through FORMAT_ERROR_BACKTRACE (Oracle 10g R2)
get error through FORMAT_ERROR_BACKTRACE [message #325266] Thu, 05 June 2008 08:19 Go to next message
Messages: 7
Registered: January 2007
Location: Uzbekistan
Junior Member
I can easy get error message at mail through event trigger, due to Dbms_Utility.FORMAT_ERROR_STACK. Like this:

but when I try to do it with FORMAT_ERROR_BACKTRACE, I get error message but it's empty.

I can't understand it.

Re: get error through FORMAT_ERROR_BACKTRACE [message #325270 is a reply to message #325266] Thu, 05 June 2008 08:37 Go to previous message
Messages: 25577
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guidelines as stated in URL above.

>I can't understand it.
Neither can I.
Do you expect us to debug code we can not see?

You're On Your Own (YOYO)!

Previous Topic: simple select from sys.user_tab_columns going all wrong in pl/sql
Next Topic: database copying
Goto Forum:

Current Time: Mon Aug 21 12:57:53 CDT 2017

Total time taken to generate the page: 0.04921 seconds