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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to obtain description about stored procedures and functions from Oracle.

From: JOSE L. rev <jlrevv_at_terraes.es>
Date: Wed, 21 Jan 2004 20:30:48 GMT
Message-ID: <YjBPb.2779032$uj6.6933135@telenews.teleline.es>

Hi, sorry my english is bad

You can recover the list of all the objects of Data Base with the table DBA_OBJECTS and the sources with the table DBA_SOURCE. The funcions and procedures are of the TYPE "FUNCTION" and "PROCEDURE".

BYE. "Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> escribió en el mensaje news:buh8cu$hmalp$1_at_ID-82536.news.uni-berlin.de...
>
> > Hi,
> >
> > Is there any way to obtain description about stored procedures and
functions
> > from Oracle database.
>
> > Ashwin.
>
> Ashwin,
>
> additionally to the already mentioned methods, there is also
> all_arguments.
>
> hth
> Rene
>
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch
Received on Wed Jan 21 2004 - 14:30:48 CST