关于mybatis批量插入oracle Null值报错的问题

关于mybatis批量插入oracle Null值报错的问题

<insert id="battchAddFlowField">
		insert into T_WORKFLOW_FIELD(ID, WF_ID, NODE_ID, FG_ID, NAME, TYPE, SORT, CREATOR, CREATE_TIME, ENABLED, REQUIRED, CSS, JS, DATA_SOURCE, GD_FIELD, GD_FIELD_TYPE, MAXLENGTH, DEFAULT_VALUE, QUICK_SEARCH)
	(<foreach collection="list" index="" item="aaa" separator="union all">
 	select
 	#{aaa.id,jdbcType=VARCHAR},#{aaa.wfId,jdbcType=VARCHAR},#{aaa.nodeId,jdbcType=VARCHAR},
 	#{aaa.FGId,jdbcType=VARCHAR},#{aaa.name,jdbcType=VARCHAR},#{aaa.type,jdbcType=VARCHAR},
 	#{aaa.sort,jdbcType=NUMERIC},#{aaa.creator,jdbcType=VARCHAR},sysdate,
 	#{aaa.enable,jdbcType=NUMERIC},#{aaa.required,jdbcType=NUMERIC},#{aaa.css,jdbcType=VARCHAR},
 	#{aaa.js,jdbcType=VARCHAR},#{aaa.dataSource,jdbcType=VARCHAR},#{aaa.GDField,jdbcType=VARCHAR},
 	#{aaa.gdfieldType,jdbcType=VARCHAR},#{aaa.maxLength,jdbcType=NUMERIC},
 	#{aaa.defaultValue,jdbcType=VARCHAR},#{aaa.quickSearch,jdbcType=VARCHAR}
 	from dual
 </foreach>)
		
	</insert>

需要加入 dbcType=VARCHAR