Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to get function/procedure name and type in a package
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-lReceived on Wed May 31 2006 - 15:20:09 CDT
![]() |
![]() |