java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Lookup Query Error in Process Form
    via by Oim Developer,
  • Send Email Notification failing
    via by 819936,
  • Target REconciliation
    via by Srivatsa.kashyap,
  • UCM starting problem
    via by 921791,
    • java.sql.SQLSyntaxErrorException: ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:942) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1690) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:446) at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:506) at com.thortech.xl.util.JDBCUtils.executeQuery(JDBCUtils.java:159) at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:760) at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271) at com.thortech.xl.dataobj.tcDataBase.readEncryptedStatement(tcDataBase.java:318) at com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readEncryptedStatement(tcDataBaseBean.java:1146) at com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readEncryptedStatementx(Unknown Source) at sun.reflect.GeneratedMethodAccessor1436.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34) at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54) at com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy357.readEncryptedStatementx(Unknown Source) at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40) at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readEncryptedStatementx(Unknown Source) at com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.activation.ActivatableServerRef.invoke(ActivatableServerRef.java:85) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518) at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

    Users with the same issue

    bpbhat77
    bpbhat771 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor2 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    71 more bugmates