oracle8.1.6 select sn2.object_id as parent_package_id, site_node.url(sn2.node_id) as parent_package_url from site_nodes sn1, site_nodes sn2 where sn1.object_id = :clickthrough_package_id and sn1.parent_id = sn2.node_id