Re: DBA Views

From: Apurba Kalita <apurba.kalita_at_lycos.com>
Date: 5 Nov 2002 09:27:33 -0800
Message-ID: <de63e470.0211050927.275bd494@posting.google.com>

You can probably use all_arguments to achieve the same. The following query would give you the public functions/procedures and the package name. If you are interested in getting only the package names u can query againt all_objects or dba_objects. Hope it helps.

opus_core_at_HL163DV1> desc all_arguments

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 OBJECT_NAME                              VARCHAR2(30)
 PACKAGE_NAME                             VARCHAR2(30)
 OBJECT_ID                       NOT NULL NUMBER
 OVERLOAD                                 VARCHAR2(40)
 ARGUMENT_NAME                            VARCHAR2(30)
 POSITION                        NOT NULL NUMBER
 SEQUENCE                        NOT NULL NUMBER
 DATA_LEVEL                      NOT NULL NUMBER
 DATA_TYPE                                VARCHAR2(30)
 DEFAULT_VALUE                            LONG
 DEFAULT_LENGTH                           NUMBER
 IN_OUT                                   VARCHAR2(9)
 DATA_LENGTH                              NUMBER
 DATA_PRECISION                           NUMBER
 DATA_SCALE                               NUMBER
 RADIX                                    NUMBER
 CHARACTER_SET_NAME                       VARCHAR2(44)
 TYPE_OWNER                               VARCHAR2(30)
 TYPE_NAME                                VARCHAR2(30)
 TYPE_SUBNAME                             VARCHAR2(30)
 TYPE_LINK                                VARCHAR2(128)
 PLS_TYPE                                 VARCHAR2(30)

opus_core_at_HL163DV1> SELECT DISTINCT OWNER,PACKAGE_NAME,OBJECT_NAME   2 FROM ALL_ARGUMENTS;

OWNER                          PACKAGE_NAME                  

OBJECT_NAME

------------------------------ ------------------------------
------------------------------
CUSTOMER                       ACX_CHQ_DISHONOUR_API         
CHEQUE_ALREADY_DISHONOURED
CUSTOMER                       ACX_CHQ_DISHONOUR_API         
CHEQUE_DISHONOUR
CUSTOMER                       ACX_CHQ_DISHONOUR_API         
CHEQUE_SEARCH
CUSTOMER                       ACX_CHQ_DISHONOUR_API         
DBG_MODE_OFF
CUSTOMER                       ACX_CHQ_DISHONOUR_API         

DBG_MODE_ON adamr1000_at_hotmail.com (Adam Rothberg) wrote in message news:<68326679.0211041547.70bd9118_at_posting.google.com>...
> Does anyone know a query I can run against the DBA_xxx views to obtain
> all packages' names within a schema and the names of the functions and
> procedures defined within each package? Similar to the way you can
> join DBA_TABLES and DBA_TAB_COLUMNS to get a list of all tables and
> the columns in those tables
>
> Thanks.
>
> -Adam
Received on Tue Nov 05 2002 - 11:27:33 CST