Devart Forums

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

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.

any news?

Thomas

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.

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.

Hello,

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