Re: How to get the list of variables and constants declared in a Oracle Package?

The only way I know of, Vivek, is to query the following:

select text from dba_source where owner=&Owner and name=&Pkg and type='PACKAGE' order by line;

hth,
John Kee

vgadge <member32788_at_dbforums.com> wrote in message news:<3086373.1057678696_at_dbforums.com>...
> Hi All,
>
> Is anyone knows the system table or method by which I can get the list
> of variables and constants declared in a Package(Oracle)?
>
> Regards
>
> Vivek
Received on Tue Jul 08 2003 - 21:51:50 CEST