it's a secret , don't tell anyone else:-)SELECT object_name AS element, DECODE(MIN(position), 0, 'FUNCTION', 'PROCEDURE') AS type FROM user_arguments WHERE package_name = '<NAMEOFPACKAGE>' GROUP BY object_namesurely you can query all_arguments with owner ..
object_name AS element,
DECODE(MIN(position), 0, 'FUNCTION', 'PROCEDURE') AS type
FROM user_arguments
WHERE package_name = '<NAMEOFPACKAGE>'
GROUP BY object_namesurely you can query all_arguments with owner ..