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

Oracle Community | Oim Developer | 2 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

    Lookup Query Error in Process Form

    Oracle Community | 2 years ago | Oim Developer
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  2. 0

    Send Email Notification failing

    Oracle Community | 6 years ago | 819936
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  3. 0

    Target REconciliation

    Oracle Community | 6 years ago | Srivatsa.kashyap
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error request using dataset which contains child form

    Oracle Community | 4 years ago | TimBenga
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  6. 0

    OIM 10g : SQL Script to Delete or Cancel process instance tasks for user resources

    Oracle Community | 4 years ago | mdadik13
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

  1. bpbhat77 1 times, last 9 months ago
8 unregistered visitors
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-00936: missing expression

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OracleStatementWrapper.executeQuery
    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.T4CStatement.doOall8(T4CStatement.java:202)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:942)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1690)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:446)
    12 frames
  3. weblogic.jdbc.wrapper
    Statement.executeQuery
    1. weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:506)
    1 frame
  4. com.thortech.xl
    tcDataBaseEJB.readEncryptedStatementx
    1. com.thortech.xl.util.JDBCUtils.executeQuery(JDBCUtils.java:159)
    2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:760)
    3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271)
    4. com.thortech.xl.dataobj.tcDataBase.readEncryptedStatement(tcDataBase.java:318)
    5. com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readEncryptedStatement(tcDataBaseBean.java:1146)
    6. com.thortech.xl.ejb.interfaces.tcDataBaseEJB.readEncryptedStatementx(Unknown Source)
    6 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1436.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  6. com.bea.core
    ReflectiveMethodInvocation.proceed
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    6 frames
  7. com.oracle.pitchfork
    MethodInvocationVisitorImpl.visit
    1. com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
    1 frame
  8. weblogic.ejb.container
    EnvironmentInterceptorCallbackImpl.callback
    1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
    1 frame
  9. com.oracle.pitchfork
    EnvironmentInterceptor.invoke
    1. com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
    1 frame
  10. com.bea.core
    JdkDynamicAopProxy.invoke
    1. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    7. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    7 frames
  11. Unknown
    $Proxy357.readEncryptedStatementx
    1. $Proxy357.readEncryptedStatementx(Unknown Source)
    1 frame
  12. com.thortech.xl
    tcDataBase_dco355_tcDataBaseRemoteImpl.__WL_invoke
    1. com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.__WL_invoke(Unknown Source)
    1 frame
  13. weblogic.ejb.container
    SessionRemoteMethodInvoker.invoke
    1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
    1 frame
  14. com.thortech.xl
    tcDataBase_dco355_tcDataBaseRemoteImpl_WLSkel.invoke
    1. com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl.readEncryptedStatementx(Unknown Source)
    2. com.thortech.xl.ejb.interfaces.tcDataBase_dco355_tcDataBaseRemoteImpl_WLSkel.invoke(Unknown Source)
    2 frames
  15. weblogic.rmi.internal
    BasicServerRef$1.run
    1. weblogic.rmi.internal.activation.ActivatableServerRef.invoke(ActivatableServerRef.java:85)
    2. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522)
    2 frames
  16. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
    1 frame
  17. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
    1 frame
  18. weblogic.rmi.internal
    WLSExecuteRequest.run
    1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518)
    2. weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
    2 frames
  19. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames