Mybatis 循环插入数据，带序列主键

<insert id="saveNCStockInfo" useGeneratedKeys="false"  parameterType="java.util.List">
        INSERT INTO MSP_STOCK_FROM_NC_INFO(
        ncstockno,
        itemno,
        packsize,
        kylqty,
        shipno,
        producedate,
        overduedate,
        inputdate,
        inputbatch,
        isdeal,
        dealtype
        )
        SELECT  MSP_NC_STOCK_SEQ.NEXTVAL,t.*
        FROM (
        <foreach collection="list" item="item" index="index"  separator="union">
        select
            #{item.goodsno,jdbcType=VARCHAR} as itemno,
            0 as packsize,
            #{item.nnum,jdbcType=VARCHAR} as kylqty,
            #{item.vbatchcode,jdbcType=VARCHAR} as shipno,
            #{item.productiondate,jdbcType=VARCHAR} as producedate,
            #{item.validityperiod,jdbcType=VARCHAR} as overduedate,
            sysdate as inputdate,
            0 as inputbatch,
            0 as isdeal,
            3 as dealtype
            from dual
        </foreach>
        ) t
    </insert>

注意union别名，没有别名报未明确定义列！