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 JANUARY 30, 2022

Applies to:

Oracle Discoverer - Version to [Release 11g]
Information in this document applies to any platform.


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:

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!

In this Document
 If you are using Discoverer or lower, you must first upgrade to
 If you are using Discoverer or

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