Kbase P123071: All scalar functions in OpenEdge 10.1x fail on array columns with error 7481
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/05/2009 |
|
Status: Unverified
SYMPTOM(s):
All scalar functions fail on array columns with error 7481
Inconsistent types (7481)
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.1B
CAUSE:
Bug# OE00147628
FIX:
Use the SQL99 notation with the SQL statement, for example:
SELECT LENGTH( MyCharCol[1] ) FROM PUB.MyTable;
OR upgrade to 10.1B03 or 10.1C
Note: The SQL99 notition will return the data in it's native datatype (the datatype defined in the Data Dictionary for the field with extents).