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

Oracle Community | Asad Hussain | 2 years ago
  1. 0

    Load Mapping Error with ODI Agent

    Oracle Community | 2 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 | 3 years ago | Anindya Chatterjee
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. 0

    Error While Compiling ODI Interface

    Oracle Community | 3 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 | 3 years ago | 1018668
    java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  6. 0

    Error while executing Interface

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