IntegerPrecision on Oracle 11g 64 Bit - 32 Bit Client

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Thomas.Schweikert
Posts: 30
Joined: Tue 27 Jun 2006 15:46

IntegerPrecision on Oracle 11g 64 Bit - 32 Bit Client

Post by Thomas.Schweikert » Fri 03 Feb 2012 15:09

Like salvador >> KLICK << we have 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.

We have an initial ora-dump to setup our application. This dump and our application works fine on Oracle 8-10.

But with Ora11 we got an error - only for 1 table -
"...integer expected - float found ..." (translated from german messagetext)

This error occurs with version 4.x or 5.x.

Thomas

--------------------------------------------------------------------------------
Delphi 7
DB: Oracle 11g R2 64 Bits 11.2.0.1.0
OS: Windows 2008 R2 Enterprise

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Mon 06 Feb 2012 12:32

Hello,

If this problem occurs when adding a field into a table with the help of the ALTER TABLE ... ADD ... construction, then it is caused by the Oracle server, which returns metadata about such field incorrectly.
Please send your dump file for the table to alexp*devart*com so that we can verify the reason for this problem.

Thomas.Schweikert
Posts: 30
Joined: Tue 27 Jun 2006 15:46

Post by Thomas.Schweikert » Tue 14 Feb 2012 13:01

any news?

Thomas

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Thu 16 Feb 2012 09:08

Hello,

As I wrote above, the problem is due to the Oracle server 11g behaviour. In your dump file, all table fields are created in the CREATE TABLE operator, and the problem doesn't occur. If you add a field using ALTER TABLE, this problem occurs.

salvador
Posts: 6
Joined: Fri 05 Nov 2004 11:57

IntegerPrecision on Oracle 11g fixed in Release 11.2.0.3

Post by salvador » Mon 20 Feb 2012 16:08

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

Post by AlexP » Tue 21 Feb 2012 09:52

Hello,

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

Post Reply