OraFAQ Forum: SQL & PL/SQL » DBMS_UTILITY.FORMAT_ERROR

Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419244]

Thu, 20 August 2009 11:59

urusman
Messages: 2
Registered: August 2009

Junior Member

How long is the longest function returned string value?

Report message to a moderator

Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419245 is a reply to message #419244]

Thu, 20 August 2009 12:01

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419247 is a reply to message #419244]

Thu, 20 August 2009 12:26

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?

Report message to a moderator

Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE returned value [message #419251 is a reply to message #419247]

Thu, 20 August 2009 12:47

Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Or change the variable definition.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 02:01:34 CST 2024