[askdba] Re: How to get names of procs,funcs within a package

  • From: Rick_Cale@xxxxxxxxxxxxxx
  • To: askdba@xxxxxxxxxxxxx
  • Date: Mon, 1 Aug 2005 16:45:20 -0400




Anthony,

User_Arguments will get all procedures and functions in a package but does
not distinguish the two.

Thanks,

Rick Cale
Database Administrator
Team Health, Inc.
865-293-5425
Rick_Cale@xxxxxxxxxxxxxx


                                                                                
                                                 
                      "Anthony                                                  
                                                 
                      Molinaro"                To:       <askdba@xxxxxxxxxxxxx> 
                                                 
                      <amolinaro@xxxxxx        cc:                              
                                                 
                      et>                      Subject:  [askdba] Re: How to 
get names of procs,funcs within a package           
                      Sent by:                                                  
                                                 
                      askdba-bounce@fre                                         
                                                 
                      elists.org                                                
                                                 
                                                                                
                                                 
                                                                                
                                                 
                      08/01/2005 04:19                                          
                                                 
                      PM                                                        
                                                 
                      Please respond to                                         
                                                 
                      askdba                                                    
                                                 
                                                                                
                                                 
                                                                                
                                                 




Rick,
  Check ALL_PROCEDURES

 - a

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Rick_Cale@xxxxxxxxxxxxxx
Sent: Monday, August 01, 2005 4:17 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] How to get names of procs,funcs within a package





Hi All,

Is there a quick way to get a list of procedures and functions within a
given package?

Thanks

Rick Cale
Database Administrator
Team Health, Inc.
865-293-5425
Rick_Cale@xxxxxxxxxxxxxx


........................................................................
.............

The information contained in this e-mail message may be privileged and
confidential. If the reader of this transmission is not the intended
recipient, you are hereby notified that any dissemination, distribution
or
copying of this communication is strictly prohibited.  If you have
received
this communication in error or are not sure whether it is privileged,
please immediately notify us by return e-mail and delete or destroy any
copies, electronic, paper or otherwise, which you may have of this
communication and any attachments.
........................................................................
.............








.....................................................................................

The information contained in this e-mail message may be privileged and
confidential. If the reader of this transmission is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this communication in error or are not sure whether it is privileged,
please immediately notify us by return e-mail and delete or destroy any
copies, electronic, paper or otherwise, which you may have of this
communication and any attachments.
.....................................................................................


Other related posts: