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_at_drn.newsguy.com>
Date: 13 Nov 2001 07:12:36 -0800
Message-ID: <9srd940grr_at_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_at_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 CorpReceived on Tue Nov 13 2001 - 16:12:36 CET