oracle 批量更新

<update id="checkPreJobPlan" parameterType="java.util.List" databaseId="oracle">
    BEGIN
    <foreach collection="eduCourse.courseMembers" item="member" separator=";">
        update numas_employee_train_record
        set audit_status = #{member.auditStatus} where course_id = #{eduCourse.id} and employee_id = (select id from numas_employee_archive where
        code = #{member.code})
    </foreach>
    ;end;
</update>