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 modifyTime              from dual          </foreach>          ) a    </insert>