Thursday 8 January 2015

ORA-00936-Missing expression error in Oracle Discoverer



 
If you are using oracle Discoverer version 11g you might get ORA-00936-Missing expression error

 

Reason:
The  DATE  field in WHERE  clause of the SQL query which is generated in Discoverer Plus will be created with wrong syntax. Screen shot for the reference.
 
 
Solution: Oracle suggests to apply the patch to resolve this issue.

You can refer oracle Doc ID 1146155.1.
 
 

 

 

No comments: