Re: Previously Undiscovered Oracle Gold

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 2 May 2006 15:58:20 -0400
Message-ID: <DeudnYCiV8lCJMrZnZ2dnUVZ_vSdnZ2d@comcast.com>

<stevedhoward_at_gmail.com> wrote in message news:1146598274.762256.223750_at_u72g2000cwu.googlegroups.com...
: That is really useful. I wonder how you could walk your way back the
: calling stack, and how large it can be?
:
: Thanks!
:
: Steve
:

i seem to recall that there's a bug in the OWA_UTIL version of this (but i may be recalling wrongly)

but the basics involve a call to 'dbms_utility.format_call_stack' and a bit of parsing, per the link that cadot posted to tom kyte's sample

i use a custom package to for conditionally logging code execution that uses this to record the name of the currently running procedure

++ mcs Received on Tue May 02 2006 - 14:58:20 CDT