Kbase P99855: Oracle error 933 when joining two tables with multiple conditions in a Where clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/6/2007 |
|
Status: Verified
FACT(s) (Environment):
OpenEdge 10.0x
Oracle DataServer
SYMPTOM(s):
Oracle error 933 when joining two tables with multiple conditions in a Where clause
Oracle error 933
ORACLE error - 933 see "ORACLE Error Messages and Codes Manual". (1252)
Oracle error 933 "** SQL command not properly ended"
The offending query joins two tables
Multiple conditions in WHERE clause
The generated SQL has 19 open brackets but 20 close brackets, thus syntax is wrong
CAUSE:
Bug# OE00112557
FIX:
Upgrade to Service pack 10.0B02 or later or 10.1A and later