MyBatis + Oracle Insert CLOB, ORA-01461: Can only bind long values to insert long column

On the internet for a long time, it is possible that the problem is now when data is taken from dual, the fields of the Clob object are converted to long

The final solution uses the BEGIN and end syntax:

1. Use the Begin and end

2. Use the INSERT INTO value () syntax

Cannot use INSERT into select from dual (union ALL) syntax

3. Parameters, specifying jdbctype=CLOB type

 
 <insert id="batchInsert" parameterType="java.util.List">
    begin
    <foreach collection="list" item="item" index="index" separator=";">
       insert into tableName(ID, content) 
       values( #{item.id},#{item.content,jdbcType=CLOB})
    </foreach> 
    ;end;
  </insert>

MyBatis + Oracle Insert CLOB, ORA-01461: Can only bind long values to insert long column