Kbase P56922: ORA-00911 on querying array logical fields
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/12/2003 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
ORACLE error -911 see "ORACLE Error Messages and Codes Manual". (1252)
** invalid character
ORA-00911 on querying array fields
The field is of logical data type
Use weekday function for logical values
The 4GL is as following
for each tab1 where arrayfld[weekday(07/16/2001)]:
display arrayfld[2].
end.
The generated SQL statement has following after where clause
arrayfld = 1##2
The correct SQL statement shoud have following after where clause
arrayfld##2 = 1.
CAUSE:
Bug 20031205-020
FIX:
Use following query instead
for each tab1 where arrayfld[weekday(07/16/2001)]=1:
display arrayfld[2].
end.