mabtis oracle批量插入报错 sql命令未正确结束

1、mabtis oracle批量插入报错 sql命令未正确结束
以下为报错sql

<insert id="insertPerformance"
            parameterType="com.creating.modules.publicHospitalPerformance.domain.performanceEty" >
        INSERT into tdu_jxkhwh(zjid, fcocod, username, xh, xmmc, dw, xmkj, zbjb,fyear)
        SELECT CreateGUID(),
        #{organCode},
        #{organName},
        xh,
        xmmc,
        dw,
        xmkj,
        zbjb,
        #{startDate}
        FROM tdu_jxkhzb_nj a
        WHERE a.bblx = '2023'
    </insert>

原因是:批量插入时，如果没有主键，一定要显式指定useGeneratedKeys为false，否则会报: SQL 命令未正确结束

以下为修改后

<insert id="insertPerformance"
            parameterType="com.creating.modules.publicHospitalPerformance.domain.performanceEty" useGeneratedKeys="false">
        INSERT into tdu_jxkhwh(zjid, fcocod, username, xh, xmmc, dw, xmkj, zbjb,fyear)
        SELECT CreateGUID(),
        #{organCode},
        #{organName},
        xh,
        xmmc,
        dw,
        xmkj,
        zbjb,
        #{startDate}
        FROM tdu_jxkhzb_nj a
        WHERE a.bblx = '2023'
    </insert>