Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value
DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419244] Thu, 20 August 2009 11:59 Go to next message
urusman
Messages: 2
Registered: August 2009
Junior Member
How long is the longest function returned string value?
Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419245 is a reply to message #419244] Thu, 20 August 2009 12:01 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
urusman wrote on Thu, 20 August 2009 09:59
How long is the longest function returned string value?


32767

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419247 is a reply to message #419244] Thu, 20 August 2009 12:26 Go to previous messageGo to next message
urusman
Messages: 2
Registered: August 2009
Junior Member
The idea was just to replace the dbms_utility.format_call_stack function by the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE.
But the dbms_utility.format_call_stack longest returned value is 2000 bytes/symbols. So we can't use the same variable to keep the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value. Or the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value need to be SUBSTR(value,1, 2000). Am I right?
Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419251 is a reply to message #419247] Thu, 20 August 2009 12:47 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or change the variable definition.

Regards
Michel
Previous Topic: Passing XMLTYPE parameter to a Web service
Next Topic: login user - user with actual db handle
Goto Forum:
  


Current Time: Wed Dec 07 04:59:45 CST 2016

Total time taken to generate the page: 0.12892 seconds