Re: Procedures and Functions in Package/Package body

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 13 Nov 2001 07:12:36 -0800
Message-ID: <9srd940grr@drn.newsguy.com>

In article <3BF12BEC.4BA52763_at_uswest.net>, Salto says...
>
>Help
>
>Using sqlplus, How do I determine the procedures and
>functions in a package / package body.
>
>I have looked at all_sources and all_objects but cannot see
>how to connect the information together.
>

all_arguments has this

>If you know what tables to use and or SQL please let me
>know.
>
>Thank You
>
>Salto_at_uswest.net
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Tue Nov 13 2001 - 09:12:36 CST