Re: PL/SQL call stack

DA Morgan wrote:
> cpiodumpv_at_gmail.com wrote:
> > In our application we have a trace utility that provides the ability to
> > instrument code.
> >
> > As part of this utility we maintain a call stack so if we are
> > instrumenting a function/procedure upon entry we push onto the stack so
> > we can log the current function/procedure executing. Upon exit we pop.
> > Is there a built in package that we can call to get the current
> > function/procedure on the stack?
> >
> > thanks in advance.
>
> dbms_utility.format_call_stack
> dbms_utility.format_error_backtrace
> dbms_utility.format_error_stack
> owa_util.who_called_me
>
> All documented with demos in Morgan's Library at www.psoug.org.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

owa_util.who_called_me will not give the name of the function/procedure only the package name. I need something like "pkg_name.procedure_name". Granted you have the line number however the requirement is to have proc/func name as well. Thanks. Received on Wed Jan 10 2007 - 15:45:47 CST