Hello,
I experience some troubles with IntegerPrecision set to 10 under Oracle 11g R2 64 Bits 11.2.0.1.0 Windows from a 32 Bits client application.
Using Devart DBExpress drivers (version 4.x or 5.x) (under the specified version of Oracle), we have fields created this way
ALTER TABLE MY_TABLE ADD MY_INT_FIELD NUMBER(10) DEFAULT 0 NOT NULL;
The fields are mapped to TFloatField instead of TIntegerField.
When the default values specified are removed, thus by creating the fields like this
ALTER TABLE MY_TABLE ADD MY_INT_FIELD NUMBER(10) NOT NULL;
The fields are correctly mapped to TIntegerField.
We first met these troubles under Oracle 11g R1 11.1.0.6.0, Windows.
How to solve this problem?
We can recompile the driver if necessary...
IntegerPrecision on Oracle 11g R2 64 Bits 11.2.0.1.0 Windows
Hello,
We checked such behavior on several Oracle servers, and such problem appears only on version 11 of the server at the field adding into the table with the help of ALTER construction . If this field is created directly at the table creation (CREATE TABLE...), then such problem doesn't appears, the field type is defined correctly as ftIntegerField.
We checked such behavior on several Oracle servers, and such problem appears only on version 11 of the server at the field adding into the table with the help of ALTER construction . If this field is created directly at the table creation (CREATE TABLE...), then such problem doesn't appears, the field type is defined correctly as ftIntegerField.
IntegerPrecision on Oracle 11g fixed in Release 11.2.0.3
Hello,
As stated on Oracle Database download page http://www.oracle.com/technetwork/datab ... eId=ocomen A Full Release, 11.2.0.3, is available through OTN. This release Fix this problem.
As stated on Oracle Database download page http://www.oracle.com/technetwork/datab ... eId=ocomen A Full Release, 11.2.0.3, is available through OTN. This release Fix this problem.