My Oracle Support Banner

Error Occurs When Running A Workbook In Discoverer 11.1.1.6 Or Earlier "ORA-00920 Invalid Relational Operator" Error Or "ORA-00936 Missing Expression" (Doc ID 1146155.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Discoverer - Version 11.1.1.1.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 29-Sep-2016***

Symptoms

Running a workbook in Discoverer Plus or Viewer 11.1.1.6, or earlier, results in an ORA-00920 and/or ORA-00936 error.
Running the same workbook in Discoverer Desktop client 10.1.2.X is fine.

Error Message:

ORA-00920: invalid relational operator


You may encounter the following error for upgraded workbooks from an earlier version:

ORA-00936: missing expression


You may have also noticed that the query generated by Discoverer has something similar to the following in the where condition, which seems to be causing the problem:

AND (SYSDATE BETWEEN (o221437.EFFECTIVE_START_DATE)(+) AND (o221437.EFFECTIVE_END_DATE)(+))

Or you may see incorrect SQL in the log file when viewed in Oracle Application Server/Enterprise Manager (EM) Console:

WHERE o106789.month + 0 = o118113.month + 0

The problem is typically occurring on workbooks that use dates in a condition (where) clause.

Changes

You may have recently upgraded Discoverer 10g to the 11g version.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 If you are using Discoverer 11.1.1.2 or lower, you must first upgrade to 11.1.1.3.
 If you are using Discoverer 11.1.1.4 or 11.1.1.6:
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.