### Error updating database. Cause: java.sql.SQLException: ORA-01722: 无效数字

Error updating database. Cause: java.sql.SQLException: ORA-01722: 无效数字

原因：

<update id="deleteByIds" parameterType="string">
        update  Menu
            set IsActive='0'
        where MenuID in
        <foreach collection="array" item="MenuID" open="(" close=")" separator=",">
            #{MenuID,jdbcType=VARCHAR}
        </foreach>
    </update>
---------------------
parameterType="string"> 定义传入的类型是String[],实际上我传入的类型Integer[]