java.sql.SQLSyntaxErrorException

ORA-00936: missing expression

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1086

  • via Oracle Community by ankist, 1 year ago
    ORA-00936: missing expression
  • via Oracle Community by Srivatsa.kashyap, 1 year ago
    ORA-00936: missing expression
  • via Oracle Community by Papai, 1 year ago
    ORA-00936: missing expression
  • Stack trace

    • java.sql.SQLSyntaxErrorException: ORA-00936: missing expression at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1378) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387) at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479) at com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source) at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source) at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source) at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.checkApprovalProcess(Unknown Source) at com.thortech.xl.dataobj.tcScheduleItem.eventPreInsert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source) at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source) at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelORC(Unknown Source) at com.thortech.xl.dataobj.util.tcProcessUtilities.cancelProcess(Unknown Source) at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source) at com.thortech.xl.dataobj.tcOIU.revokeObjectInstance(Unknown Source) at com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.revokeObjects(Unknown Source) at com.thortech.xl.ejb.beans.tcUserOperationsSession.revokeObjects(Unknown Source) at com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.revokeObjects(tcUserOperations_voj9p2_EOImpl.java:2285) at Thor.API.Operations.tcUserOperationsClient.revokeObjects(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.security.Security.runAs(Security.java:41) at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source) at Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source) at $Proxy60.revokeObjects(Unknown Source) at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.revokeProvisionedResources(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) at com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source) at com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source) at com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source) at com.thortech.xl.webclient.actions.ProvisionedResourcesForUserAction.execute(Unknown Source) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3592) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2202) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2108) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1432) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 1 year ago
    Unknown user
    Once, 10 months ago
    Unknown user
    2 times, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    543 more bugmates