Error: ORA-00936: MISSING EXPRESSION, When "DISTINCT" Is Capitalized On Saved Query Used On Workbench
(Doc ID 2522171.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.4.3 and laterInformation in this document applies to any platform.
Symptoms
If the "distinct" clause is in LOWER case, the saved query works as expected on a workbench.
If the "DISTINCT" clause is in UPPER case in a saved query the following error is seen in application logs.
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 |
Cause |
Solution |
References |