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

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

--
Posted via http://dbforums.com