<insert id="insertDimensionDetails" parameterType="java.util.List" useGeneratedKeys="false">
    insert into QUOTA_DIMENSION_DETAIL
    (ID,DIMENSION_ID,CODE_VALUE,UPDATE_DATE,COLNAME_ID)
    SELECT SEQ_QUOTA_DIMENSION_DETAIL.NEXTVAL,a.* FROM (
    <foreach collection="list" item="item" separator="union all">
        SELECT
        #{item.dimensionId},#{item.codeValue},#{item.updateDate},#{item.colnameId}
        FROM dual
    </foreach>
    ) a
</insert>

前面括号中主键必须写，不然报错值过多

useGeneratedKeys="false" 设置为false  不然有问题