Re: How to get all the function and Procedures included in a package
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 13 Feb 2003 09:45:59 +0100
Message-ID: <1045125757.346854_at_news.thyssen.com>
Date: Thu, 13 Feb 2003 09:45:59 +0100
Message-ID: <1045125757.346854_at_news.thyssen.com>
"Vishnu" wrote...
> I need to get all the functions and the procedures in a package given
> the package name.Is there any PL/SQL construt which can be used to do
> so..Or any Oracle database System table which can be queried to get
> them..Any oher alternative ???
> anyone who came across the same problem before????
>
> Rgds
> Vishnu
Hi Vishnu,
have a look at user_arguments. And I bet you find it useful to get familiar with 'select * from dict;'.
hth,
Guido
Received on Thu Feb 13 2003 - 09:45:59 CET