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: 24971
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: execute immediate with nvarchar data type
Next Topic: How I add 2 hours to some time variable?
Goto Forum:

Current Time: Fri Oct 28 01:42:49 CDT 2016

Total time taken to generate the page: 0.12692 seconds