IntegerPrecision on Oracle 11g 64 Bit - 32 Bit Client

IntegerPrecision on Oracle 11g 64 Bit - 32 Bit Client

Postby 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
Thomas.Schweikert
 
Posts: 30
Joined: Tue 27 Jun 2006 15:46

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

Postby Thomas.Schweikert » Tue 14 Feb 2012 13:01

any news?

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

Postby 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.
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:08

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


Return to dbExpress driver for Oracle