when we deploy changes to the database we have simple trigger has changes example :
create or replace editionable trigger mr.dept_tb before
insert on mr.emp
referencing
new as new
old as old
for each row
declare
tmpvar number;
begin
:new.empno := 1;
end;
/
alter trigger mr.dept_tb enable;
after generate arifact with trigger change set project deploy return :
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
then we do some more search and run the liquibase update statement to debug the error shown bellow:
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
DEBUG:
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.command.CommandScope.execute(CommandScope.java:237)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.Scope.child(Scope.java:250)
at oracle.dbtools.raptor.liquibase.core.ActiveCommand.runCommand(ActiveCommand.java:434)
at oracle.dbtools.raptor.liquibase.core.CommandGenerator.updateCommand(CommandGenerator.java:382)
at oracle.dbtools.raptor.scriptrunner.commands.liquibase.LbCommand.handleEvent(LbCommand.java:330)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:448)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:236)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:833)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:119)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1223)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1401)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:370)
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:146)
at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:99)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:97)
at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
at liquibase.command.CommandScope.execute(CommandScope.java:214)
... 17 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:797)
at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:119)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:68)
at liquibase.changelog.ChangeLogIterator$2.lambda$run$0(ChangeLogIterator.java:128)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:117)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.Scope.child(Scope.java:250)
at liquibase.Scope.child(Scope.java:254)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:84)
... 25 more
Caused by: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:470)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:179)
at oracle.dbtools.raptor.liquibase.executor.jvm.SqlClExecutor.execute(SqlClExecutor.java:103)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1291)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1273)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:755)
... 40 more
Caused by: java.sql.SQLException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:709)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:609)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1347)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1100)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:408)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:499)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:190)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1399)
at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:2008)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1621)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2686)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2635)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:336)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:464)
... 46 more
Caused by: Error : 6550, Position : 16, SQL = begin
null;
end, Original SQL = begin
null;
end, Error Message = ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:717)
... 59 more
DEBUG:
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.command.CommandScope.execute(CommandScope.java:237)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.Scope.child(Scope.java:250)
at oracle.dbtools.raptor.liquibase.core.ActiveCommand.runCommand(ActiveCommand.java:434)
at oracle.dbtools.raptor.liquibase.core.CommandGenerator.updateCommand(CommandGenerator.java:382)
at oracle.dbtools.raptor.scriptrunner.commands.liquibase.LbCommand.handleEvent(LbCommand.java:330)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:448)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:236)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:833)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:119)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1223)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1401)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:370)
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:146)
at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:99)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:97)
at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
at liquibase.command.CommandScope.execute(CommandScope.java:214)
... 17 more
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset trigger/dept_tb1.sql::1ee7588cd5d7984752fce2e587419cdcc108ce39::MR:
Reason: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:797)
at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:119)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:68)
at liquibase.changelog.ChangeLogIterator$2.lambda$run$0(ChangeLogIterator.java:128)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:117)
at liquibase.Scope.lambda$child$0(Scope.java:184)
at liquibase.Scope.child(Scope.java:193)
at liquibase.Scope.child(Scope.java:183)
at liquibase.Scope.child(Scope.java:162)
at liquibase.Scope.child(Scope.java:250)
at liquibase.Scope.child(Scope.java:254)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:84)
... 25 more
Caused by: liquibase.exception.DatabaseException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/ [Failed SQL: (6550) begin
null;
end]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:470)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:179)
at oracle.dbtools.raptor.liquibase.executor.jvm.SqlClExecutor.execute(SqlClExecutor.java:103)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1291)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1273)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:755)
... 40 more
Caused by: java.sql.SQLException: ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
https://docs.oracle.com/error-help/db/ora-06550/
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:709)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:609)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1347)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1100)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:408)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:499)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:190)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1399)
at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:2008)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1621)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2686)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2635)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:336)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:464)
... 46 more
Caused by: Error : 6550, Position : 16, SQL = begin
null;
end, Original SQL = begin
null;
end, Error Message = ORA-06550: line 3, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:717)
... 59 more
best regards,