oracle 8.1.6 update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 select item_id from cr_revisions where revision_id = :revision_id update cr_revisions set content_length = lob_length(lob) where revision_id = :revision_id update cr_revisions set mime_type = :mime_type, content = empty_blob() where revision_id = :revision_id select storage_area_key, filename from cr_items ci, cr_revisions cr where cr.item_id=ci.item_id and cr.revision_id=:revision_id