mysql 迁移到 oracle后mybatis 不支持多条语句同时执行错误信息 ORA-00911: 无效字符

柠檬加点茶儿

于 2019-06-03 08:59:01 发布

阅读量874

点赞数

分类专栏： java 文章标签： ROA-00911:无效字符多条sql语句执行

本文链接：https://blog.csdn.net/oMengQiQi1/article/details/90746694

版权

java 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

之前项目mysql mybatis delete为：(mysql连接中添加allowMultiQueries=true)

<delete id="xxx" parameterType="map">
        delete from A where USER_ID = #{userId};
        delete from B where USER_ID = #{userId};
        delete from C where USER_ID = #{userId};
        delete from D where USER_ID = #{userId};
</delete>

ORA-00911: 无效字符，其实提示的是第一条sql语句的分号是无效字符，因为oracle把begin end 之间的作为一条SQL来执行。

现在oracle mybatis delete 中添加 begin end

<delete id="xxx" parameterType="map">
        begin
	        delete from A where USER_ID = #{userId};
	        delete from B where USER_ID = #{userId};
	        delete from C where USER_ID = #{userId};
	        delete from D where USER_ID = #{userId};
        end;
</delete>