Kbase P17910: Is there a way of making Oracle NUMBER map to Progress DECIMAL by default?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Is there a way of making Oracle NUMBER map to Progress DECIMAL by default?
FACT(s) (Environment):
How to map Oracle NUMBER datatype to Progress DECIMAL?
Progress 9.x
FIX:
It is not possible to have Oracle datatype to be mapped by default to Progress DECIMAL.
The rule is that if Oracle Field is defined as NUMBER with precision and decimal, Progress will map it into a DECIMAL.
However, if the Oracle field is NUMBER without precision and decimal, it will be mapped to INTEGER in the Progress Schema Holder.