Index: openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql,v diff -u -r1.34 -r1.35 --- openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 9 Nov 2008 23:29:26 -0000 1.34 +++ openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 22 Jan 2010 19:58:42 -0000 1.35 @@ -260,8 +260,7 @@ select site_node.url(node_id) from site_nodes - where object_id = (select r.package_id, - r.folder_id as root_folder_id + where object_id = (select r.package_id from fs_root_folders r, (select item_id as folder_id from cr_items