oracle8.1.6 select mime_type from cr_revisions where item_id = :attach_id and revision_id = content_item.get_latest_revision (:attach_id) delete from images where image_id = content_item.get_latest_revision(:attach_id) begin acs_message.delete_image(:attach_id); end; begin acs_message.delete_file(:attach_id); end; begin content_extlink.del(:attach_id); end;