Index: openacs-4/packages/acs-content-repository/tcl/content-item-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/Attic/content-item-procs-oracle.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-content-repository/tcl/content-item-procs-oracle.xql	28 Aug 2020 14:51:34 -0000	1.1.2.1
+++ openacs-4/packages/acs-content-repository/tcl/content-item-procs-oracle.xql	31 Oct 2023 12:55:44 -0000	1.1.2.2
@@ -12,4 +12,11 @@
       (r.filename is not null and i.storage_type = 'file'))
     </querytext>
   </fullquery>
+
+  <partialquery name="item::get_revision_content.grc_get_all_content_1">
+    <querytext>
+      , content.blob_to_string(content) as text
+    </querytext>
+  </partialquery>
+
 </queryset>