oracle8.1.6 select count(*) from evaluation_student_evals ese, evaluation_tasks est where ese.party_id = :party_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't' and est.task_id = :task_id and est.task_item_id = ese.task_item_id select count(*) from evaluation_student_evals ese, evaluation_tasks est where ese.party_id = :party_id and ese.task_item_id = :task_item_id and content_revision.is_live(ese.evaluation_id) = 't' and ese.task_item_id = est.task_item_id and est.task_id = :task_id update cr_revisions set content = empty_blob(), filename = :tmp_filename where revision_id = :revision_id returning content into :1 update cr_revisions set filename = :file_name, mime_type = :mime_type, content_length = :content_length where revision_id = :revision_id