Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to get function/procedure name and type in a package

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

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Wed, 31 May 2006 22:20:09 +0200
Message-ID: <447DFA79.1050603@roughsea.com>


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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]*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
Received on Wed May 31 2006 - 15:20:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US