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;]
via liquibase.org by Unknown author, 2 years ago
Error executing SQL CREATE  TRIGGER IS_PI_AFTER_UPDATE     END: ERROR: missing ";" at end of SQL statement     AFTER UPDATE     ON USERS     FOR EACH ROW For more information, use the --logLevel flag)     DECLARE     BEGIN         IF
via Apereo Issues by Dan McCallum, 1 year ago
Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19
via Apereo Issues by Dan McCallum, 1 year ago
Error executing SQL INSERT INTO [dbo].[campus] ([created_by], [created_date], [description], [early_alert_coordinator_id], [id], [modified_by], [modified_date], [name], [object_status]) VALUES ('58BA5EE3-734E-4AE9-B9C5-943774B4DE41', '2012-05-17 19
via JIRA by feng yang, 1 year ago
Error executing SQL CREATE TABLE [DB].[FILTER_COMPONENT_DBF] ([TIMESTAMP] DATETIME NULL, [M_IDENTITY] NUMERIC(10) NOT NULL, [M_REFERENCE] NUMERIC(10) NOT NULL, [M_OPERATOR] numeric(2) NOT NULL, [M_FILTER_COMPONENT_PARENT__ID] NUMERIC(10) NOT NULL): The identifier that starts with '[M_FILTER_COMPONENT_PARENT__I' is too long. Maximum length is 28.
via GitHub by ThomasBassa
, 1 year ago
Index "SUB_ENTRY_READ_INDEX" belongs to constraint "FKD6DCE994E181535F"; SQL statement: DROP INDEX PUBLIC.sub_entry_read_index [90085-190] [Failed SQL: DROP INDEX PUBLIC.sub_entry_read_index]
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(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:307)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:309)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:113)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1277)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1259)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:582)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
at liquibase.Liquibase.update(Liquibase.java:214)
at liquibase.Liquibase.update(Liquibase.java:192)
at liquibase.Liquibase.update(Liquibase.java:335)
at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:33)
at org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask(AbstractLiquibaseUpdateMojo.java:30)
at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute(AbstractLiquibaseMojo.java:394)

Users with the same issue

Once, 2 months ago
Once, 9 months ago
10 times, 9 months ago
6 times, 1 year ago
2 times, 1 year ago

Write tip

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