oracle数据库使用mybatis批量插入

<insert id="insertSelective" useGeneratedKeys="true" parameterType="java.util.List">    <!--      WARNING - @mbggenerated      This element is automatically generated by MyBatis Generator, do not modify.    -->    <selectKey keyProperty="id" order="BEFORE" resultType="java.math.BigDecimal">      select DISCOUNT_COUPON_PERSON_SEQ.NEXTVAL from DUAL    </selectKey>    insert into T_DISCOUNT_COUPON_PERSON     ( ID,        USER_ID,        COUPON_ID,        ORDER_SHOP_ID,        COUPON_GET_WAY,        COUPON_GET_CHANNEL,        COUPON_GET_DATE,        COUPON_USE_DATE,        MONEY_BACK_APPLY_DATE,        COUPON_USE_STATUS,        CANCEL_LOCK_REASON,        CREATE_TIME,        MODIFY_TIME)    select logsaccessseq.NEXTVAL,a.* from (<foreach collection="list" item="item" index="index"separator="union all">select#{item.userId,jdbcType=DECIMAL} as userId,#{item.couponId,jdbcType=VARCHAR} as couponId,#{item.orderShopId,jdbcType=VARCHAR} as orderShopId,#{item.couponGetWay,jdbcType=VARCHAR} as couponGetWay,#{item.couponGetChannel,jdbcType=VARCHAR} as couponGetChannel,#{item.couponGetDate,jdbcType=TIMESTAMP} as couponGetDate,#{item.couponUseDate,jdbcType=TIMESTAMP} as couponUseDate,#{item.moneyBackApplyDate,jdbcType=TIMESTAMP} as moneyBackApplyDate,#{item.couponUseStatus,jdbcType=VARCHAR} as couponUseStatus,#{item.cancelLockReason,jdbcType=VARCHAR} as cancelLockReason,#{item.createTime,jdbcType=TIMESTAMP} as createTime,#{item.modifyTime,jdbcType=TIMESTAMP} as modifyTimefrom dual</foreach>) a  </insert>