Re: how to get function/procedure name and type in a package

From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
To: GMei@xxxxxx
Date: Wed, 31 May 2006 22:20:09 +0200

Guang,

You can use the DBMS_DESCRIBE.DESCRIBE_PROCEDURE. For functions, the function type is returned as if it where a dummy argument at position 0.

HTH


STéphane Faroult

Guang Mei wrote:

Yes, that works in sqlplus. But I want to get them in my pl/sql program. Guang

    -----Original Message-----
    *From:* oracle-l-bounce@xxxxxxxxxxxxx
    [mailto:oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *Goulet, Dick
    *Sent:* Wednesday, May 31, 2006 3:47 PM
    *To:* Guang Mei; Oracle-L (E-mail)
    *Subject:* RE: how to get function/procedure name and type in a
    package

    Describe <package_name> is the bext I know of.


--
http://www.freelists.org/webpage/oracle-l

References:

RE: how to get function/procedure name and type in a package
From: Guang Mei

Re: how to get function/procedure name and type in a package

Other related posts: