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

tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    loadData generating invalid Oracle SQL

    Stack Overflow | 5 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;]

    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.apache.maven.lifecycle.internal.MojoExecutor.execute()
    2. Maven Core
      DefaultMaven.execute
      1. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:212)
      2. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
      3. org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
      4. org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
      5. org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
      6. org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
      7. org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
      8. org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
      9. org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
      10. org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
      10 frames
    3. M3 Interceptor
      MavenCli.main
      1. org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
      2. org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
      3. org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
      3 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    5. Plexus
      Launcher.main
      1. org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
      2. org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
      3. org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
      4. org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
      4 frames