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.25.2.4 -r1.25.2.5
--- openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 26 May 2004 18:13:02 -0000 1.25.2.4
+++ openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 21 Jul 2004 22:37:18 -0000 1.25.2.5
@@ -142,6 +142,22 @@
+
+
+ select person.name(o.creation_user) as owner
+ from acs_objects o where o.object_id = :file_id
+
+
+
+
+
+ select site_node.url(node_id) as path1 from site_nodes
+ where object_id = (select package_id
+ from fs_root_folders where
+ fs_root_folders.folder_id = :root_folder)
+
+
+
select content