Kbase P51798: Data type error when transferring data from Oracle to Progress via ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Data type error when transferring data from Oracle to Progress via ODBC
Incompatible data types in expression or assignment [223] [SQL State 22005 SQL Code 223]
The data is date: '01/02/03' as it should be valid whether dd/mm/yy, mm/dd/yy or yy/mm/dd is used.
Using the syntax "update amsuptrans@intray set "suttrandate" = '01/02/03' "
CAUSE:
The syntax "update amsuptrans@intray set "suttrandate" = '01/02/03' " is not supported by SQL-92 and need to be transformed before the Query can be executed against SQL-92 DB.
FIX:
Use the function TO_CHAR transform the Query.
Refer to Progress SQL-92 Guide and Reference (Page 4-109).