Index: openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql,v diff -u -r1.10 -r1.10.2.1 --- openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql 4 Mar 2004 14:52:35 -0000 1.10 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-revision.sql 5 Apr 2004 01:13:52 -0000 1.10.2.1 @@ -204,10 +204,10 @@ -- create the basic revision (using v_target_item_id) insert into cr_revisions ( revision_id, title, description, publish_date, mime_type, - nls_language, content, item_id + nls_language, content, item_id, content_length ) ( select v_copy_id, title, description, publish_date, mime_type, nls_language, - content, v_target_item_id + content, v_target_item_id, content_length from cr_revisions where