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)