findpkg.sql

set feedback off
accept package_name PROMPT 'Please enter Package name:'
SELECT DISTINCT procedure$ "&package_name"
FROM sys.argument$, dba_objects
WHERE obj# = object_id
AND object_name = &package_name;
set feedback on