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

    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;]
  3. 0

    PL/SQL and SQL script in one sqlFile with liquibase?

    Stack Overflow | 1 year ago | Gabor
    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') ]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    triggers in sql files with oracle 11g database don't work

    codedmi.com | 1 year ago
    liquibase.exception.DatabaseException: Error executing SQL END IF: ORA-00900: ugyldig SQL-setning

    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. 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;]

      at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute()
    2. org.liquibase.maven
      AbstractLiquibaseMojo.execute
      1. org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:398)
      1 frame
    3. Maven Plugin
      DefaultBuildPluginManager.executeMojo
      1. org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
      1 frame
    4. Maven Core
      MojoExecutor.execute
      1. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207)
      1 frame