Kbase P117672: Oracle Error 1461 with a schema holder containing definition of an earlier Progress Version
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
Oracle DataServer
SYMPTOM(s):
ORACLE error -1461 when creating a record against an ORACLE table
** can bind a LONG value only for insert into a LONG column
The table has a LONG column within ORACLE
The table has been loaded from a schema holder generated with an earlier Progress version
The DB-LINK-NAME property is informed for the table in the .df file
CAUSE:
The exact cause is unknown at the time of this writing.
FIX:
To fix this problem, remove the DB-LINK-NAME information in the .df file and re-load the table into the schema holder.
Follow the steps below:
1. Delete the DB-LINK-NAME related to the table in the .df file dumped from Progress 8.
2. Delete the table in the schema holder from the Data Dictionary
3. Load the .df file modified in step #1 into the schema holder from Data Administration.