java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

Oracle Community | 793564 | 6 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

    get lookup decode values

    Oracle Community | 6 years ago | 793564
    java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
  2. 0

    Site Studio 11g--unable to get search results

    Oracle Community | 6 years ago | oim11guser
    java.sql.SQLSyntaxErrorException: ORA-00904: "CONTAINS": invalid identifier
  3. 0

    UCM starting problem

    Oracle Community | 5 years ago | 921791
    intradoc.common.ServiceException: !csSchemaUnableToPublishView,EBSDocClassView
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while notifying on resource provisioning

    Oracle Community | 7 years ago | user1464585
    java.sql.SQLSyntaxErrorException: ORA-00936: manglende udtryk
  6. 0

    unable to access the url http:\\hostname:16300\urm "server unavailable"

    Oracle Community | 4 years ago | 753060
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view 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-00907: missing right parenthesis

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OracleStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
    9. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
    12 frames
  3. weblogic.jdbc.wrapper
    Statement.executeQuery
    1. weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479)
    1 frame
  4. com.thortech.xl
    tcLookupOperations_u50o5o_ELOImpl.getLookupValuesForEncoded
    1. com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
    2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
    3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
    4. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    5. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    6. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    8. com.thortech.xl.ejb.beansimpl.tcLookupOperationsBean.getLookupValuesForEncoded(Unknown Source)
    9. com.thortech.xl.ejb.beans.tcLookupOperationsSession.getLookupValuesForEncoded(Unknown Source)
    10. com.thortech.xl.ejb.beans.tcLookupOperations_u50o5o_ELOImpl.getLookupValuesForEncoded(tcLookupOperations_u50o5o_ELOImpl.java:484)
    10 frames
  5. Thor.API.Operations
    tcLookupOperationsClient.getLookupValuesForEncoded
    1. Thor.API.Operations.tcLookupOperationsClient.getLookupValuesForEncoded(Unknown Source)
    1 frame
  6. com.thortech.xl
    tcFormInstanceOperations_2j82mm_EOImpl.setProcessFormData
    1. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpTESTGPADAPTER.GET(adpTESTGPADAPTER.java:137)
    2. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpTESTGPADAPTER.implementation(adpTESTGPADAPTER.java:62)
    3. com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)
    4. com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)
    5. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source)
    6. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    8. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    9. com.thortech.xl.dataobj.tcScheduleItem.insertResponseMilestones(Unknown Source)
    10. com.thortech.xl.dataobj.tcScheduleItem.eventPostUpdate(Unknown Source)
    11. com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
    12. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    13. com.thortech.xl.adapterfactory.events.tcAdpEvent.updateSchItem(Unknown Source)
    14. com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeProcessAdapter(Unknown Source)
    15. com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeAdapter(Unknown Source)
    16. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpADCSPTCREATEUSER.implementation(adpADCSPTCREATEUSER.java:105)
    17. com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)
    18. com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)
    19. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source)
    20. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)
    21. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    22. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    23. com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(Unknown Source)
    24. com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(Unknown Source)
    25. com.thortech.xl.dataobj.tcOrderItemInfo.completeCarrierBaseMilestone(Unknown Source)
    26. com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(Unknown Source)
    27. com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(Unknown Source)
    28. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    29. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    30. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    31. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.setProcessFormData(Unknown Source)
    32. com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.setProcessFormData(Unknown Source)
    33. com.thortech.xl.ejb.beans.tcFormInstanceOperationsSession.setProcessFormData(Unknown Source)
    34. com.thortech.xl.ejb.beans.tcFormInstanceOperations_2j82mm_EOImpl.setProcessFormData(tcFormInstanceOperations_2j82mm_EOImpl.java:554)
    34 frames
  7. Thor.API.Operations
    tcFormInstanceOperationsClient.setProcessFormData
    1. Thor.API.Operations.tcFormInstanceOperationsClient.setProcessFormData(Unknown Source)
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1549.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  9. Thor.API.Base
    SecurityInvocationHandler$1.run
    1. Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source)
    1 frame
  10. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  11. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  12. weblogic.security
    Security.runAs
    1. weblogic.security.Security.runAs(Security.java:41)
    1 frame
  13. Thor.API.Security
    weblogicLoginSession.runAs
    1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source)
    1 frame
  14. Thor.API.Base
    SecurityInvocationHandler.invoke
    1. Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source)
    1 frame
  15. Unknown
    $Proxy67.setProcessFormData
    1. $Proxy67.setProcessFormData(Unknown Source)
    1 frame
  16. com.thortech.xl
    DirectProvisionUserAction.goNext
    1. com.thortech.xl.webclient.actions.DirectProvisionUserAction.handleVerifyProcessData(Unknown Source)
    2. com.thortech.xl.webclient.actions.DirectProvisionUserAction.goNext(Unknown Source)
    2 frames
  17. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor646.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  18. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
    1 frame
  19. com.thortech.xl
    tcAction.execute
    1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source)
    2. com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source)
    3. com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source)
    3 frames
  20. struts
    ActionServlet.doPost
    1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    3. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    4. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    4 frames
  21. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  22. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  23. com.thortech.xl
    SecurityFilter.doFilter
    1. com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
    1 frame
  24. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592)
    2 frames
  25. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  26. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  27. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432)
    3 frames
  28. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    2 frames