Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL call stack

Re: PL/SQL call stack

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 10 Jan 2007 12:03:12 -0800
Message-ID: <1168459388.529734@bubbleator.drizzle.com>


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
Received on Wed Jan 10 2007 - 14:03:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US