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

[padderz]

Since when did DESC list variables and constants declared in a package?

--
Posted via http://dbforums.com

[Tom]

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

Try:

select * from USER_ARGUMENTS
where package_name = 'the_package_na me'
and object_name = 'the_function_n ame'