Re: procedures in packages

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 22 Oct 1999 13:55:23 -0400
Message-ID: <u6QQOEceMvTmnZS2NXoqkXIVp4a1@4ax.com>

A copy of this was sent to "James Belton" <jbelton_at_freenetname.co.uk> (if that email address didn't require changing) On Fri, 22 Oct 1999 07:35:17 +0100, you wrote:

>how can I use just SQL*plus to see what procedures are in a package?
>
>Is there a table, something like ALL_PACKAGE_BODIES which I can use?
>
>
>
>James
>

tkyte_at_8i> desc dbms_output
PROCEDURE DISABLE
PROCEDURE ENABLE

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 BUFFER_SIZE                    NUMBER(38)              IN     DEFAULT

PROCEDURE GET_LINE
......

tkyte_at_8i> select distinct package_name, object_name from all_arguments where package_name = 'DBMS_OUTPUT';

PACKAGE_NAME                   OBJECT_NAME
------------------------------ ------------------------------
DBMS_OUTPUT                    DISABLE
DBMS_OUTPUT                    ENABLE
DBMS_OUTPUT                    GET_LINE
DBMS_OUTPUT                    GET_LINES
DBMS_OUTPUT                    NEW_LINE
DBMS_OUTPUT                    PUT
DBMS_OUTPUT                    PUT_LINE

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Oct 22 1999 - 12:55:23 CDT