RE: Parsing the Call Stack

From: Lange, Kevin G <kevin.lange_at_ppoone.com>
Date: Thu, 21 Apr 2011 10:05:37 -0500
Message-ID: <F077F09A0E11504D9E720358BEE994D10785E489_at_APSW0553EVS.ms.ds.uhc.com>

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_at_lsualumni.com [mailto:jj_at_lsualumni.com] Sent: Wednesday, April 20, 2011 11:39 PM To: oracle-l_at_freelists.org; 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_at_ppoone.com> 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_at_jameyj.com]
> Sent: Wednesday, April 20, 2011 3:42 PM
> To: Lange, Kevin G
> Cc: <oracle-l_at_freelists.org>
> Subject: Re: Parsing the Call Stack
>
>
> pstack <spid>
>
>
>
>
>
> jbj2
>
> --
>
> Jamey Johnston
>
> On Apr 20, 2011, at 2:52 PM, "Lange, Kevin G" <kevin.lange_at_ppoone.com>
> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 21 2011 - 10:05:37 CDT