Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL call stack
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
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.orgReceived on Wed Jan 10 2007 - 14:03:12 CST
![]() |
![]() |