oracle8.1.6 update download_archive_revisions set approved_p = :approved_p, approved_comment = :approved_comment, approved_user = :user_id, approved_date = sysdate where revision_id = :revision_id