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

vgadge wrote:
> Hi John,
>
> Thanks for the reply. I know this way of geting the list. But to get the
> list from dba_source table, I have to do the string manipulation which
> is not very reliable way. I wanted it in such a way like some SQL
> editors provide us. Just by entering the Procedure or Package name and
> entering dot next it, it gives us the list of variable declared in the
> procedure.
>
> Regards
>
> Vivek
>
> Originally posted by John Kee
>

>>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