oracle8.1.6 select round(86400 * (sysdate - completed_datetime)) as cur_wait_time from as_sessions where session_id = :last_session_id update as_assessments set instructions=empty_clob(),consent_page=empty_clob() where assessment_id=:as_assessment_id returning instructions, consent_page into :1, :2 update as_assessments set instructions=empty_clob(),consent_page=empty_clob() where assessment_id=:new_rev_id returning instructions, consent_page into :1, :2 update as_assessments set instructions=empty_clob(),consent_page=empty_clob() where assessment_id=:new_rev_id returning instructions, consent_page into :1, :2