IntegerPrecision on Oracle 11g R2 64 Bits 11.2.0.1.0 Windows

IntegerPrecision on Oracle 11g R2 64 Bits 11.2.0.1.0 Windows

Postby salvador » Mon 09 Jan 2012 14:36

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...
salvador
 
Posts: 6
Joined: Fri 05 Nov 2004 11:57

Postby AlexP » Wed 11 Jan 2012 09:35

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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

IntegerPrecision on Oracle 11g fixed in Release 11.2.0.3

Postby salvador » Mon 20 Feb 2012 16:10

Hello,

As stated on Oracle Database download page http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen A Full Release, 11.2.0.3, is available through OTN. This release Fix this problem.
salvador
 
Posts: 6
Joined: Fri 05 Nov 2004 11:57

Postby AlexP » Fri 24 Feb 2012 14:27

Hello,

Thank you for the information. We will check our dbExpress driver with this Oracle version and let you know the results.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Postby AlexP » Mon 27 Feb 2012 09:51

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
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle