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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by AfterWorkGuinness
, 1 year ago
', , ''); 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;]
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(AbstractLiquibaseMojo.java:398)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.