Re: Can you get a description of a function from the Oracle-datadictionary??

From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 11 Aug 2003 18:20:43 GMT
Message-ID: <%7RZa.32168$It3.943438@twister.socal.rr.com>

wybrand wrote:

> Hi,
>
> I have the following question: I want to get a description of a
> function like substr or a user defined function from the
> datadictionary. For instance I want to know which datatype the
> function returns and what many in-, out- and in/out parameters the
> function has and of which type they are.
>
> Is this possible??
>
> Thank you in advance.
>
> Greetings,
>
> Wybrand.

Have a look at ALL_PROCEDURES and ALL_ARGUMENTS.

Richard Received on Mon Aug 11 2003 - 13:20:43 CDT