java.sql.SQLSyntaxErrorException: ORA-00926: missing VALUES keyword

Oracle Community | hammer | 2 years ago
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

    Error during Mapping execution after changing the order of Datasets

    Oracle Community | 2 years ago | hammer
    java.sql.SQLSyntaxErrorException: ORA-00926: missing VALUES keyword
  2. 0

    ODI-1228: Task INT-EXP-FF-ORC (Integration) fails on the target ORACLE conn

    Oracle Community | 6 years ago | user705850
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. 0

    Error delete previous check sum

    Oracle Community | 6 years ago | 883344
    java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI - Moving source files of ODI from different server to ODI server.

    Oracle Community | 5 years ago | 793252
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  6. 0

    ODI error java.sql.SQLSyntaxErrorException: ORA-01918

    Oracle Community | 5 years ago | 894341
    java.sql.SQLSyntaxErrorException: ORA-01918: user 'STGMGR' does not exist
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.SQLSyntaxErrorException

    ORA-00926: missing VALUES keyword

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1079)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
    12 frames
  3. oracle.odi.runtime
    TaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
    2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
    4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
    4 frames
  4. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:537)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
    5 frames
  5. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:338)
    1 frame
  6. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
    1 frame
  7. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:272)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:263)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:822)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  8. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame