liquibase.exception.DatabaseException: ORA-06550: line 6, column 267: PL/SQL: ORA-00917: missing comma ORA-06550: line 6, column 1: PL/SQL: SQL Statement ignored ORA-06550: line 8, column 189: PL/SQL: ORA-00933: SQL command not properly ended ORA-06550: line 8, column 1: PL/SQL: SQL Statement ignored [Failed SQL: DECLARE v_reccount NUMBER := 0; BEGIN SELECT COUNT(*) INTO v_reccount FROM CONFIGURATION WHERE CONFIGURATION_ID = 3590; IF v_reccount = 0 THEN INSERT INTO CONFIGURATION (CONFIGURATION_ID, SERVICE_NAME, CATEGORY, CONFIGURATION_KEY, CONFIGURATION_VALUE, CREATE_TS, CREATED_BY, UPDATED_TS, UPDATED_BY) VALUES (3590, 'MobileCloudWallet', 'SYSTEM_PROPERTIES', 'VTS.Wallet.Provider.Type', 'XX,UGO,APPLE', 26-SEP-16 09.52.05.708089000 AM, 'SYSTEM', , ''); ELSIF v_reccount = 1 THEN UPDATE CONFIGURATION SET CATEGORY = 'SYSTEM_PROPERTIES', CONFIGURATION_KEY = 'VTS.Wallet.Provider.Type', CONFIGURATION_VALUE = 'XX,UGO,APPLE', CREATED_BY = 'SYSTEM', CREATE_TS = 26-SEP-16 09.52.05.708089000 AM, SERVICE_NAME = 'MobileCloudWallet', UPDATED_BY = '', UPDATED_TS = WHERE CONFIGURATION_ID = 3590; END IF; END;]

  1. 0

    loadData generating invalid Oracle SQL

    Stack Overflow | 2 months ago | AfterWorkGuinness
    liquibase.exception.DatabaseException: ORA-06550: line 6, column 267: PL/SQL: ORA-00917: missing comma ORA-06550: line 6, column 1: PL/SQL: SQL Statement ignored ORA-06550: line 8, column 189: PL/SQL: ORA-00933: SQL command not properly ended ORA-06550: line 8, column 1: PL/SQL: SQL Statement ignored [Failed SQL: DECLARE v_reccount NUMBER := 0; BEGIN SELECT COUNT(*) INTO v_reccount FROM CONFIGURATION WHERE CONFIGURATION_ID = 3590; IF v_reccount = 0 THEN INSERT INTO CONFIGURATION (CONFIGURATION_ID, SERVICE_NAME, CATEGORY, CONFIGURATION_KEY, CONFIGURATION_VALUE, CREATE_TS, CREATED_BY, UPDATED_TS, UPDATED_BY) VALUES (3590, 'MobileCloudWallet', 'SYSTEM_PROPERTIES', 'VTS.Wallet.Provider.Type', 'XX,UGO,APPLE', 26-SEP-16 09.52.05.708089000 AM, 'SYSTEM', , ''); ELSIF v_reccount = 1 THEN UPDATE CONFIGURATION SET CATEGORY = 'SYSTEM_PROPERTIES', CONFIGURATION_KEY = 'VTS.Wallet.Provider.Type', CONFIGURATION_VALUE = 'XX,UGO,APPLE', CREATED_BY = 'SYSTEM', CREATE_TS = 26-SEP-16 09.52.05.708089000 AM, SERVICE_NAME = 'MobileCloudWallet', UPDATED_BY = '', UPDATED_TS = WHERE CONFIGURATION_ID = 3590; END IF; END;]
  2. 0

    How to translate SQL trigger to liquibase

    Stack Overflow | 1 year ago | user3139545
    liquibase.exception.DatabaseException: ORA-06550: line 5, column 15: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; [Failed SQL: begin if :new.myid is null then select seq_myseq.nextval into :new.myid from dual]
  3. 0

    Upgrade to 2.3.2 to 2.5.6 fails in Oracle

    GitHub | 2 years ago | joseorsini
    com.dotmarketing.exception.DotRuntimeException: ORA-02289: sequence does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error loading fresh starter Oracle

    GitHub | 5 years ago | dotjorgeu
    java.sql.SQLException: ORA-00907: missing right parenthesis
  6. 0

    Java Sql Exception - No more data to read from socket

    Stack Overflow | 3 years ago | Ashish
    java.sql.SQLException: No more data to read from socket

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-06550: line 6, column 267: PL/SQL: ORA-00917: missing comma ORA-06550: line 6, column 1: PL/SQL: SQL Statement ignored ORA-06550: line 8, column 189: PL/SQL: ORA-00933: SQL command not properly ended ORA-06550: line 8, column 1: PL/SQL: SQL Statement ignored

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.execute
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
      8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
      10. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
      11. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
      12. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
      12 frames
    3. Liquibase Core
      Liquibase.update
      1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
      2. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
      3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
      4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
      5. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
      6. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
      7. liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
      8. liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
      9. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
      10. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
      11. liquibase.Liquibase.update(Liquibase.java:214)
      12. liquibase.Liquibase.update(Liquibase.java:192)
      13. liquibase.Liquibase.update(Liquibase.java:335)
      13 frames
    4. org.liquibase.maven
      AbstractLiquibaseMojo.execute
      1. org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:33)
      2. org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask(AbstractLiquibaseUpdateMojo.java:30)
      3. org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:394)
      3 frames