mybatis怎樣批量插入數據到oracle，就算id自動增長問題

<insert id="addTMsgSmsinfoForBatch" parameterType="java.util.List">

<selectKey resultType="long" keyProperty="id" order="BEFORE">

SELECT T_MSG_SMSINFO_SEQ.NEXTVAL AS id FROM dual

</selectKey>

INSERT INTO T_MSG_SMSINFO ( <include refid="columns_auotmsgsending" /> ) VALUES

<foreach collection="list" item="item" index="index"

separator=",">

( #{item.id},#{item.ecid},#{item.userid},#{item.sendermsisdn},#{item.receiverinfo},

#{item.totalrec},#{item.smsorigin},#{item.originid},#{item.smscontent},#{item.smstype},

#{item.scheduletime},#{item.auditstatus},#{item.inserttime},#{item.updatetime}

)

</foreach>

</insert>

就是在：

<selectKey resultType="long" keyProperty="id" order="BEFORE">

SELECT T_MSG_SMSINFO_SEQ.NEXTVAL AS id FROM dual

</selectKey>

有問題