My Oracle Support Banner

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

Last updated on MAY 25, 2018

Applies to:

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


Running a workbook in Discoverer Plus or Viewer, 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:


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.


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


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

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

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