Index: openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql	22 Jun 2002 17:28:32 -0000	1.9
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql	22 Jun 2002 20:09:31 -0000	1.10
@@ -48,11 +48,11 @@
         </querytext>
     </fullquery>
 
-    <fullquery name="site_node_closest_ancestor_package_url.select_url">
+    <fullquery name="site_node::get_url_from_object_id.select_url_from_object_id">
         <querytext>
             select site_node.url(node_id)
             from site_nodes
-            where object_id = :subsite_pkg_id
+            where object_id = :object_id
         </querytext>
     </fullquery>