我尝试了很多选项在 room ChangeSet/sqlFile 中运行,其中包含 pl/sql 块和简单的 sql 语句。例如。:
BEGIN
aud.someProcedure('parameter');
END;
/
insert into test_table(_id, value) VALUES(1, 'test');
但我得到以下异常:
liquibase.exception.MigrationFailedException: Migration failed for change set [xml path]:
Reason: liquibase.exception.DatabaseException: ORA-06550: 4 line, 1 col:
PLS-00103: Encountered the symbol: "/"
[Failed SQL: BEGIN
aud.someProcedure('parameter');
END;
//
insert into test_table(_id, value) VALUES(1, 'test')
]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:584)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
at liquibase.Liquibase.update(Liquibase.java:210)
at liquibase.Liquibase.update(Liquibase.java:190)
at liquibase.Liquibase.update(Liquibase.java:186)
at org.jenkinsci.plugins.liquibase.builder.LiquibaseBuilder.perform(LiquibaseBuilder.java:128)
at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
at hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:779)
at hudson.model.Build$BuildExecution.build(Build.java:205)
at hudson.model.Build$BuildExecution.doRun(Build.java:162)
at hudson.model.AbstractBuild$AbstractBuildExecution.run(AbstractBuild.java:537)
at hudson.model.Run.execute(Run.java:1741)
at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
at hudson.model.ResourceController.execute(ResourceController.java:98)
at hudson.model.Executor.run(Executor.java:381)
Caused by: liquibase.exception.DatabaseException: ORA-06550: 4 line, col oszlop:
PLS-00103: Encountered the symbol: "/"
[Failed SQL: BEGIN
aud.someProcedure('parameter');
END;
//
insert into test_table(_id, value) VALUES(1, 'test')
]
当我尝试更改 xml 中的 splitStatement 和 endDelimiter 时,没有任何变化。
你有什么主意吗?
“endDelimiter”工作完美。
SQL语句中的分号会产生“无效字符错误”,因此当它不是分隔符时必须将其删除。
(是的,它在 PL/SQL 和 SQL*Plus 中起作用,就像斜杠“/”,更多:在 Oracle SQL 中什么时候需要使用分号和斜线? https://stackoverflow.com/questions/1079949/when-do-i-need-to-use-a-semicolon-vs-a-slash-in-oracle-sql )
解决方案:
-
结束符=“/”
<changeSet id="1" author="me">
<sql endDelimiter="/">
BEGIN
aud.someProcedure('parameter');
END;
/
insert into test_table(_id, value) VALUES(1, 'test')
</sql>
</changeSet>
-
两节
<changeSet id="1" author="me">
<sql endDelimiter="/">
BEGIN
aud.someProcedure('parameter');
END;
</sql>
<sql>
insert into test_table(_id, value) VALUES(1, 'test');
</sql>
</changeSet>
-
或者可能 ;)
<changeSet id="1" author="me">
<sql endDelimiter="#Gabor was here#">
BEGIN
aud.someProcedure('parameter');
END;
#Gabor was here#
insert into test_table(_id, value) VALUES(1, 'test')
</sql>
</changeSet>
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)