Index: openacs-4/packages/cms/tcl/item-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/Attic/item-procs-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/tcl/item-procs-oracle.xql	20 Aug 2001 04:35:41 -0000	1.2
+++ openacs-4/packages/cms/tcl/item-procs-oracle.xql	2 Sep 2001 14:24:58 -0000	1.3
@@ -3,6 +3,20 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+
+ 
+<fullquery name="item::content_is_null.cin_get_content">      
+      <querytext>
+      
+    select 't' from cr_revisions r, cr_items i
+      where r.revision_id = :revision_id
+        and i.item_id = r.item_id
+        and ((r.content is not null and i.storage_type in ('lob','text')) or
+             (r.filename is not null and i.storage_type = 'file'))
+      </querytext>
+</fullquery>
+
+
 <fullquery name="item::get_best_revision.gbr_get_best_revision">      
       <querytext>