oracle8.1.6 update cr_revisions set filename =:file_path, content_length = :file_size where revision_id = :revision_id update cr_revisions set content = empty_blob(), content_length = [file size $file] where revision_id = :revision_id returning content into :1 update cr_revisions set content = empty_blob(), content_length = [file size $file] where revision_id = :revision_id returning content into :1 content_item.get_latest_revision(:item_id)