oracle8.1.6 select package_id from apm_packages where package_key = 'acs-developer-support' and rownum=1 select acs_object.name(:object_id) from dual select site_node.url(node_id) from site_nodes s, apm_packages p where p.package_id = s.object_id and p.package_key ='acs-developer-support' and rownum = 1