RE: Parsing the Call Stack

From: Lange, Kevin G <kevin.lange_at_ppoone.com>
Date: Wed, 20 Apr 2011 16:14:45 -0500
Message-ID: <F077F09A0E11504D9E720358BEE994D10785DF65_at_APSW0553EVS.ms.ds.uhc.com>

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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 20 2011 - 16:14:45 CDT