oracle8.1.6 update cr_revisions set filename = :file_name, mime_type = :mime_type, content_length = :content_length where revision_id = :revision_id update cr_revisions set content = empty_blob(), filename = :filename where revision_id = :revision_id returning content into :1 select crr.title as content, crr.title, crr.item_id, cri.storage_type, crr.revision_id, crr.content_length, crr.mime_type crr.filename from cr_items cri, cr_revisions crr where crr.revision_id = :attachment_id and crr.item_id = cri.item_id