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