Re: How to obtain description about stored procedures and functions from Oracle.

Ashwin K Gudidevuni wrote:

> Hi,
>
> Is there any way to obtain description about stored procedures and functions
> from Oracle database.
>
> Thank you in advance.
> Ashwin.

If by description you mean the parameters:

SQL> desc <procedure_name>

If you mean the source code it is stored in source$ and accessable through user_source, all_source, and dba_source views.

If you have 9i the best way to recover it is with DBMS_METADATA.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)