Mybatis Oracle Merge into CLOB类型的数据

1.在对象类中将该属性定义为String类型

    private String id;
    private String name;
    private String age;
    private String describe;//该属性为CLOB类型

2.在对应的xml中写下相应的SQL语句

<insert id="insert" parameterType="java.util.ArrayList">
	<foreach collection="list" item="item" index="index" open="begin" close="end;">
		MERGE INTO TABLE_NAME A USING (
			SELECT
			#{item.id       , jdbcType=VARCHAR} ID      ,
			#{item.name     , jdbcType=VARCHAR} NAME    ,
			#{item.age      , jdbcType=VARCHAR} AGE     ,
			#{item.describe , jdbcType=CLOB} DESCRIBE
			FROM DUAL
		) B ON (
			A.ID= B.ID
		)
		WHEN NOT MATCHED THEN
		INSERT (
			ID             ,
			NAME           ,
			AGE            ,
			DESCRIBE
		)
		VALUES (
			B.ID           ,
			B.NAME         ,
			B.AGE          ,
			B.DESCRIBE
		);
	</foreach>
</insert>