Re: Procedures within Packages

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 11 Jul 2001 16:39:50 -0700
Message-ID: <9iio460126v@drn.newsguy.com>

In article <3B4CD690.677D6441_at_d2mail.de>, Martin says...
>
>Oracle 8.1.6.3.0 EE Sun Sparc Solaris.
>
>I can do "describe PACKAGENAME" in sqlplus which will give me all parts of a
>package that are visible outside.
>
>I can use the dbms_describe.describe_procedure only for procedures.
>
>I have to know the procedures within a package from within PL/SQL. How do I find
>out *that*?
>
>The only workaround until now is
>

ops$tkyte_at_ORA8I.WORLD> select distinct object_name 2 from user_arguments
3 where package_name = 'EMP_PKG';

OBJECT_NAME

EMPQUERY_REFCUR ops$tkyte_at_ORA8I.WORLD> desc emp_pkg
PROCEDURE EMPQUERY_REFCUR

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 BLOCK_DATA                     REF CURSOR              IN/OUT
                                RECORD                  IN/OUT
     EMPNO                      NUMBER(4)               IN/OUT
     ENAME                      VARCHAR2(10)            IN/OUT
 P_DEPTNO                       NUMBER                  IN

>spool tmp.lst
>describe PACKAGENAME
>spool off
>
>Load tmp.lst to a work table by e. g. sqlldr. Then do the analysis.
>
>Better idea?
>
>Martin

--
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 Wed Jul 11 2001 - 18:39:50 CDT