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.4 -r1.5
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql	1 Dec 2001 17:55:16 -0000	1.4
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql	1 Feb 2002 15:16:20 -0000	1.5
@@ -21,13 +21,13 @@
 
 <fullquery name="site_nodes_sync_helper.nodes_select">      
       <querytext>
-      
+
     select site_node.url(n.node_id) as url, n.node_id, n.directory_p,
            n.pattern_p, n.object_id, o.object_type, n.package_key, n.package_id
     from acs_objects o, (select n.node_id, n.directory_p, n.pattern_p, n.object_id, p.package_key, p.package_id
                            from site_nodes n, apm_packages p
-                          where n.object_id = p.package_id) n
-    where n.object_id = o.object_id
+                          where n.object_id = p.package_id (+) ) n
+    where n.object_id = o.object_id (+);
   
       </querytext>
 </fullquery>