Index: openacs-4/packages/acs-content-repository/tcl/content-revision-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/content-revision-procs-oracle.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/acs-content-repository/tcl/content-revision-procs-oracle.xql	31 May 2006 13:42:30 -0000	1.6
+++ openacs-4/packages/acs-content-repository/tcl/content-revision-procs-oracle.xql	23 Jul 2009 12:30:27 -0000	1.7
@@ -58,6 +58,17 @@
           where revision_id = :revision_id
       </querytext>
   </fullquery>
+
+  <fullquery name="content::revision::get_cr_file_path.get_storage_key_and_path">
+    <querytext>	
+      select storage_area_key, 
+          filename
+      from cr_items ci, 
+          cr_revisions cr 
+      where cr.item_id=ci.item_id 
+          and cr.revision_id=:revision_id
+    </querytext>
+  </fullquery>
   
 </queryset>