Kbase P113608: FOR EACH query failing with "SQL command not properly ended" ORA-00933
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
Oracle DataServer
SYMPTOM(s):
FOR EACH parcel WHERE parcel.num_order = 02211
AND ( parcel.groupname = "" OR parcel.groupname = parcel.code )
USE-INDEX num_order NO-LOCK,
EACH place OF parcel:
ORACLE error -933 see "ORACLE Error Messages and Codes Manual". (1252)
** SQL command not properly ended
CAUSE:
As seen within "dataserv.lg", the SQL statement generated by Oracle DataServer is having one too many ")" at the end of the OR clause.
FIX:
Either upgrade to OpenEdge10 or modify the order of the OR clause within the query, as per
FOR EACH parcel WHERE parcel.num_order = 02211
AND ( parcel.groupname = "" OR parcel.code = parcel.groupname)
USE-INDEX num_order NO-LOCK,
EACH place OF parcel: