oracle8.1.6 select acs_object.name(:package_id) from dual select site_node.url(n.node_id) as url, acs_object.name(n.object_id) as name from site_nodes n where n.parent_id = :node_id and n.object_id is not null