RE: Parsing the Call Stack

The program can be called from more than one source.  He only needs the
one that just called him so the dependencies view will not work in this
case.

________________________________

From: jj@xxxxxxxxxxxxx [mailto:jj@xxxxxxxxxxxxx] 
Sent: Wednesday, April 20, 2011 11:39 PM
To: oracle-l@xxxxxxxxxxxxx; Lange, Kevin G
Subject: RE: Parsing the Call Stack



Sorry, read your request a total different way! :-) You should be able
to use the dba_dependencies view to do this. 

 

Here is a link to a post by Jared Still on this with a script -
http://ss64.com/ora/sql-dependencies.html

 

 

On April 20, 2011 at 5:14 PM "Lange, Kevin G" <kevin.lange@xxxxxxxxxx>
wrote:

> Was looking more for something that could be called from a procedure
> that would give the names of the procedures/packages from the current
> procedure on down.
> 
> For example, if I have a procedure that is called X and it calls a
> procedure called Y which calls a procedure called Z, the dbms_utility
> function returns something like this when called from procedure Z:
> 
> 
> FORMAT_CALL_STACK
>
------------------------------------------------------------------------
> --------
> ----- PL/SQL Call Stack -----
>   object      line  object
>   handle    number  name
> 38ab66d13         4  procedure Z
> 38da54a34         5  procedure Y
> 38da33a22         2  procedure X
> 38da59f28         1  anonymous block
>
> Its one long line but it is parsable on character 10.  I can parse it
> but would prefer having something that might return simular data in an
> array or table or something simpler.
> 
> ________________________________
>
> From: Jamey Johnston [mailto:jj@xxxxxxxxxx]
> Sent: Wednesday, April 20, 2011 3:42 PM
> To: Lange, Kevin G
> Cc: <oracle-l@xxxxxxxxxxxxx>
> Subject: Re: Parsing the Call Stack
>
>
> pstack <spid>
>
>
>
>
>
> jbj2
>
> --
>
> Jamey Johnston
>
> On Apr 20, 2011, at 2:52 PM, "Lange, Kevin G" <kevin.lange@xxxxxxxxxx>
> wrote:
>
>
>
>         Howdy All;
>           Does anyone know an easier way to retrieve the Program Call
> Stack other than parsing the output string from
> dbms_utility.format_call_stack ?  We have a developer who would like
to
> know where his code is being called from for debugging/logging
purposes.
>         
>         We are using  Oracle 10g (lowest version 10.2.0.3) on Solaris
> 10g.
>         
>         Thanks
>         
>         Kevin
>
>         
>         This e-mail, including attachments, may include confidential
> and/or
>         proprietary information, and may be used only by the person or
> entity
>         to which it is addressed. If the reader of this e-mail is not
> the intended
>         recipient or his or her authorized agent, the reader is hereby
> notified
>         that any dissemination, distribution or copying of this e-mail
> is
>         prohibited. If you have received this e-mail in error, please
> notify the
>         sender by replying to this message and delete this e-mail
> immediately.
>
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity
> to which it is addressed. If the reader of this e-mail is not the
intended
> recipient or his or her authorized agent, the reader is hereby
notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify
the
> sender by replying to this message and delete this e-mail immediately.


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

Other related posts: