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 + +