Set this constant to define the type of NUMBER fields with Scale > 0.
FloatPrecision: integer = 15;
Set this constant to define the type of NUMBER fields with Scale > 0. If its precision is less than or equal to FloatPrecision the field will be defined as TFloatField. Otherwise it will be defined as TOraNumberField (if TOraSessionOptions.EnableNumbers option is set to True).
According to these constants and TOraSessionOptions.EnableIntegers and TOraSessionOptions.EnableNumbers options, Oracle NUMBER type is mapped to ODAC field classes in the following way:
Conditions | Field class |
---|---|
Precision <= IntegerPrecision, Scale = 0, TOraSessionOptions.EnableIntegers = True | TIntegerField |
IntegerPrecision < Precision <= LargeIntPrecision, Scale = 0, TOraSessionOptions.EnableIntegers = True | TLargeIntField |
Precision > FloatPrecision, Scale > 0, TOraSessionOptions.EnableNumbers = True | TOraNumberField |
In other cases | TFloatField |
FloatPrecision: integer = 15;