java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator

Oracle Community | steve80lyon | 2 years ago
  1. 0

    BI Publisher Data-Models : text parameter (with comma-separated) nullity test

    Oracle Community | 2 years ago | steve80lyon
    java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator
  2. 0

    Bi Publisher errors on multiselect

    Oracle Community | 3 months ago | deahayes
    java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
  3. 0

    Invalid identifier when linking more than one data sets in a data model

    Oracle Community | 6 years ago | 862563
    java.sql.SQLSyntaxErrorException: ORA-00904: "MANAGER_KEY_2": invalid identifier[[
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid relational operator in rawsql, same statement works in sqldeveloper

    Stack Overflow | 3 years ago | Nico Müller
    java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator
  6. 0

    list of filesnames not read by variable in odi

    Stack Overflow | 1 year ago | user5297374
    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-00920: invalid relational operator

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
    13 frames
  3. oracle.xdo.dataengine
    DataProcessor.processData
    1. oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1672)
    2. oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:467)
    3. oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:392)
    4. oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:293)
    5. oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:226)
    6. oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1587)
    7. oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1355)
    8. oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:376)
    8 frames
  4. oracle.xdo.servlet
    XDOServlet.doGet
    1. oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:318)
    2. oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:672)
    3. oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:290)
    4. oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:346)
    5. oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:101)
    6. oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1113)
    7. oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:649)
    8. oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:492)
    9. oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:462)
    10. oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:261)
    10 frames
  5. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  6. 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:300)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  7. oracle.xdo.servlet
    MostRecentFilter.doFilter
    1. oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:64)
    1 frame
  8. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  9. oracle.xdo.servlet
    SecurityFilter.doFilter
    1. oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:124)
    1 frame
  10. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  11. oracle.xdo.servlet
    InitCheckingFilter.doFilter
    1. oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
    1 frame
  12. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  13. oracle.security.jps
    JpsAbsFilter$1.run
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    1 frame
  14. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  15. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
    2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
    3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    5 frames
  16. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  17. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
    1 frame
  18. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
    3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
    5 frames
  19. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  20. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  21. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
    3 frames
  22. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
    2 frames