Index: openacs-4/packages/acs-content-repository/tcl/acs-content-repository-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/acs-content-repository-procs-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/tcl/acs-content-repository-procs-oracle.xql	27 Sep 2002 15:03:52 -0000	1.1.2.1
@@ -0,0 +1,16 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="cr_delete_scheduled_files.fetch_paths">      
+      <querytext>
+
+select distinct crftd.path storage_area_key
+          from cr_files_to_delete crftd
+           and not exists (select 1 
+                             from cr_revisions r 
+                            where r.filename = crftd.path) 
+      </querytext>
+</fullquery>
+
+</queryset>