Kbase P14009: Numeric field appear as logical in the Dataserver Oracle Schema holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/05/2010 |
|
Status: Verified
SYMPTOM(s):
Numeric field appear as logical in the DataServer Oracle schema holder
Using numeric field with only one position long in Oracle
Field created in the schema holder is number(logic) instead of number(integer)
FACT(s) (Environment):
Progress 8.x
Progress 9.x
OpenEdge 10.x
Oracle DataServer
CAUSE:
Starting in DataServer Oracle 8.0x to support the Boolean data type that does not exist in Oracle, DataServer Oracle takes number fields with one position long in Oracle and creates a field as number(logic).
FIX:
If the field requires numeric values instead logical values, manually modify the schema holder by using the Data Dictionary and following the steps:
1. Select the numeric field
2. Choose field properties
3. On the Data type dialog change from Numeric (logic) to Numeric (integer).