java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Oracle Community | Asad Hussain | 3 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

    Load Mapping Error with ODI Agent

    Oracle Community | 3 years ago | Asad Hussain
    java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
  2. 0

    File to RT Error In Interface While Concurrent Scheduling

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

    Error While Compiling ODI Interface

    Oracle Community | 4 years ago | 1018668
    java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Query regarding ODI Joins

    Oracle Community | 4 years ago | 1018668
    java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  6. 0

    Error while executing Interface

    Oracle Community | 4 years ago | 1029060
    java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
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-00933: SQL command not properly ended

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    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:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
    6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)
    6 frames
  5. oracle.odi.runtime
    StartScenRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
    1 frame
  6. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  7. oracle.odi.runtime
    DefaultAgentTaskExecutor$1.run
    1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
    2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
    3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)
    4 frames
  8. Spring Core
    SyncTaskExecutor.execute
    1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
    1 frame
  9. oracle.odi.runtime
    AgentServlet.doPost
    1. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)
    2. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)
    3. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)
    4. oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)
    5. oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)
    6. oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)
    6 frames
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  11. Jetty Server
    SocketConnector$Connection.run
    1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
    2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)
    3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
    5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
    6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
    7. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    8. org.mortbay.jetty.Server.handle(Server.java:326)
    9. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
    10. org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
    11. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)
    12. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
    13. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    14. org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
    14 frames
  12. Jetty Util
    QueuedThreadPool$PoolThread.run
    1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)
    1 frame