Kbase P117407: Error 1461 accessing timestamp fields in Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/09/2008 |
|
Status: Verified
SYMPTOM(s):
Error 1461 accessing timestamp fields in Oracle
Schema holder does not match database schema -- file field . (1461)
The table schema is successfully pulled into schema holder
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
CAUSE:
timestamp field is not supported in Oracle data server
FIX:
The only way to correct would be to either create a view on that table which would not include that field or to change the field data type to "date". If you create the view, you would delete the table definition from the schema holder and pull the view instead.