Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sqlcl project deploy trigger changeset error

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,

Comments

BluShadow Mar 18 2024

Oracle support documents are available to paying customers through the support portal: support.oracle.com

If you are not a paying customer then I'm afraid you won't have access to the document, and it is a breach of any customer's agreement with Oracle to supply such support documents to others.

1 - 1

Post Details

Added on Feb 9 2025
2 comments
103 views