java.sql.SQLSyntaxErrorException: ORA-00905: missing keyword

Oracle Community | user13773143 | 1 year 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

    No Columns are set to update column in Target Datastore

    Oracle Community | 1 year ago | user13773143
    java.sql.SQLSyntaxErrorException: ORA-00905: missing keyword
  2. 0

    ODI : java.sql.SQLSyntaxErrorException: ORA-02019: connection description for remote database not found

    Oracle Community | 2 years ago | 2670946
    java.sql.SQLSyntaxErrorException: ORA-02019: connection description for remote database not found
  3. 0

    Mapping issue !

    Oracle Community | 2 years ago | 2814059
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    CDC - Simple  ORA-00904: "JRN_FLAG": invalid identifier

    Oracle Community | 2 years ago | 2967828
    java.sql.SQLSyntaxErrorException: ORA-00904: "JRN_FLAG": invalid identifier
  6. 0

    invalid character when running liquibase script

    Stack Overflow | 3 years ago | Marthin
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

  1. jpvee 2 times, last 2 months ago
3 unregistered visitors
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-00905: missing keyword

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OracleStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
    8. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
    9. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
    11. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168)
    12. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100)
    13. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363)
    13 frames
  3. oracle.odi.runtime
    TaskExecutorAgentRequestProcessor$1.doAction
    1. oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
    2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141)
    3. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
    4. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
    5. oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
    6. oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
    7. oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864)
    8. oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024)
    9. oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
    10. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
    11. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
    11 frames
  4. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
    1 frame
  5. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
    5 frames
  6. Java RT
    Executors$RunnableAdapter.call
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    1 frame
  7. oracle.odi.runtime
    OdiJob.call
    1. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    2. oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
    2 frames
  8. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:262)
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    4. java.lang.Thread.run(Thread.java:745)
    4 frames