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.9.2.1 -r1.9.2.2
--- openacs-4/packages/acs-content-repository/tcl/content-revision-procs-oracle.xql 22 Feb 2021 11:47:19 -0000 1.9.2.1
+++ openacs-4/packages/acs-content-repository/tcl/content-revision-procs-oracle.xql 6 Apr 2021 19:16:16 -0000 1.9.2.2
@@ -64,12 +64,19 @@
select storage_area_key,
filename
- from cr_items ci,
- cr_revisions cr
+ from cr_items ci, cr_revisions cr
where cr.item_id=ci.item_id
and cr.revision_id=:revision_id
+
+
+
+ select content
+ from cr_revisions
+ where revision_id = :revision_id
+
+