oracle8.1.6 select doc.get_package_header(:package_name) from dual select doc.get_proc_header(:proc_name, :package_name) from dual select distinct lower(name) as label, lower(name) as value from user_source where type='PACKAGE' and line=1 order by label select distinct lower(text) as line_header from user_source where type='PACKAGE' and lower(name) = lower(:package_name) and ( lower(text) like '%procedure%' or lower(text) like '%function%' ) order by line_header select distinct lower(text) as line_header from user_source where type='PACKAGE' and lower(name) = lower(:package_name) and ( lower(text) like '%procedure%' or lower(text) like '%function%' ) order by line_header