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.


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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006