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

Oracle Community | Oim Developer | 2 years ago
  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 | 3 years ago | mdadik13
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

  1. bpbhat77 1 times, last 6 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