Index: openacs-4/packages/edit-this-page/www/etp-edit-2-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/Attic/etp-edit-2-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/edit-this-page/www/etp-edit-2-oracle.xql	31 Oct 2001 04:29:31 -0000	1.2
+++ openacs-4/packages/edit-this-page/www/etp-edit-2-oracle.xql	20 Nov 2001 02:04:50 -0000	1.3
@@ -5,9 +5,18 @@
 <fullquery name="create_new_revision">
 <querytext>
 begin
-  etp.create_new_revision(:package_id, :name, :user_id) from dual;
+  :1 := etp.create_new_revision(:package_id, :name, :user_id);
 end;
 </querytext>
 </fullquery>
  
+<fullquery name="update_content_attribute_clob">
+<querytext>
+    update cr_revisions
+    set    content = empty_blob()
+    where  revision_id = :latest_revision_id
+    returning content into :1
+</querytext>
+</fullquery>
+ 
 </queryset>