[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    RE: Package name for a procedure/function
From:       Finn Ellebaek Nielsen <finn.ellebaek.nielsen () changegroup ! dk>
Date:       2004-05-19 10:23:56
Message-ID: F001.005E4F34.20040519031424 () fatcity ! com
[Download RAW message or body]

My understanding was that the info is needed at runtime, but I may be wrong.

Cheers,

Finn

--- Paul Dorsey <pdorsey@dulcian.com> wrote:
> It might be easier to just use something like SQL Nav to do a code
> search on the name of the proc.
> Paul 
> 
> > -----Original Message-----
> > From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On 
> > Behalf Of Finn Ellebaek Nielsen
> > Sent: Wednesday, May 19, 2004 5:29 AM
> > To: Multiple recipients of list ODTUG-SQLPLUS-L
> > Subject: Re: Package name for a procedure/function
> > 
> > 
> > Hi Ajay.
> > 
> > Through DBMS_UTILITY.FORMAT_CALL_STACK. Here's an example:
> > 
> > create or replace package pack as 
> >   procedure proc;
> > end;
> > /
> > 
> > create or replace package body pack as
> >   procedure proc as
> >   
> >   begin
> >     dbms_output.put_line(dbms_utility.format_call_stack);
> >   end proc;
> > end;
> > /
> > 
> > execute pack.proc
> > 
> > ----- PL/SQL Call Stack -----
> >   object      line  object
> >   handle    number  name
> > 55ca3a08         5  package body SCOTT.PACK
> > 541c2264         1  anonymous block
> > 
> > You just need to do some intelligent parsing on the call 
> > stack returned by DBMS_UTILITY.FORMAT_CALL_STACK in order to 
> > get the name of the package.
> > 
> > HTH.
> > 
> > Cheers,
> > 
> > Finn
> > 
> > --- Ajay_K_Garg@Dell.com wrote:
> > > Hi
> > > 
> > > I have a stored procedure which is part of a package.
> > > I want to know the name of the package to which this stored 
> > procedure 
> > > belongs. What is the easiest way to do this?
> > > 
> > > Tia & Regards
> > > 
> > > Ajay
> > > 
> > 
> > 
> > =====
> > --------------------------------------------------------------
> > -------------
> >  Finn Ellebaek Nielsen                           ChangeGroup ApS
> >  Product Manager, Principal Consultant, Partner  
> > Kronprinsessegade 54, 4.
> >  E-mail: finn.ellebaek.nielsen@changegroup.dk    DK-1306  Koebenhavn K
> >  Mobile: +45 20 32 49 25                         Denmark
> >  Phone:  +45 33 32 77 78                         
> > http://www.changegroup.dk
> > 
> > --------------------------------------------------------------
> > -------------
> > ChangeGroup PL/SQL Server Pages: Web-enable PL/SQL code and developers
> > ChangeGroup Open System Documentary: Oracle system 
> > documentation generator
> > -- 
> > ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the 
> > Westin Kierland
> > Resort, Scottsdale, Arizona.  Visit http://www.odtug.com for 
> > details.-- 
> > Author: Finn Ellebaek Nielsen
> >   INET: finn.ellebaek.nielsen@changegroup.dk
> > 
> > Fat City Hosting, San Diego, California -- http://www.fatcity.com
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > 
> 
> 
> -- 
> ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin Kierland
> Resort, Scottsdale, Arizona.  Visit http://www.odtug.com for details.-- 
> Author: Paul Dorsey
>   INET: pdorsey@dulcian.com
> 
> Fat City Hosting, San Diego, California -- http://www.fatcity.com
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


=====
---------------------------------------------------------------------------
 Finn Ellebaek Nielsen                           ChangeGroup ApS
 Product Manager, Principal Consultant, Partner  Kronprinsessegade 54, 4.
 E-mail: finn.ellebaek.nielsen@changegroup.dk    DK-1306  Koebenhavn K
 Mobile: +45 20 32 49 25                         Denmark
 Phone:  +45 33 32 77 78                         http://www.changegroup.dk
---------------------------------------------------------------------------
ChangeGroup PL/SQL Server Pages: Web-enable PL/SQL code and developers
ChangeGroup Open System Documentary: Oracle system documentation generator
-- 
ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin Kierland
Resort, Scottsdale, Arizona.  Visit http://www.odtug.com for details.-- 
Author: Finn Ellebaek Nielsen
  INET: finn.ellebaek.nielsen@changegroup.dk

Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]