IntegerPrecision on Oracle 11g R2 64 Bits 11.2.0.1.0 Windows

[salvador]

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...

[AlexP]

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.

[salvador]

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.

[AlexP]

Hello,

Thank you for the information. We will check our dbExpress driver with this Oracle version and let you know the results.

[AlexP]

Hello,

We have checked obtaining meta-data about the cols created with the ALTER TABLE ADD construction at the latest Oracle 11.2.0.3 - the problem is really fixed in this patch. For correct work with such fields, you should update your Oracle Server