Kbase P107585: Getting error 3782 with the nested FOR EACH query run against Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/26/2011 |
|
Status: Verified
SYMPTOM(s):
Getting error 3782 with the nested FOR EACH query run against Oracle DataServer
Field <field-num> from <file-name> record (recid <RECID>) was missing from FIELDS phrase. (3782)
FACT(s) (Environment):
Clicking OK on the above error, client hangs until the client process is killed
The nested FOR EACH query has IF-THEN-ELSE function in the WHERE clause.
OpenEdge 10.0B
OpenEdge 10.0B02 service pack is installed
Oracle DataServer
All Supported Operating Systems
CAUSE:
Bug# OE00118638
FIX:
The workaround is to re-write the query to move the IF function to the body of the FOR loop or use the field list on a nested query.