Devart Forums

Posted: **Wed 03 Jun 2009 11:07**

Hi!

After installing ODAC version 6.80.0.47 I still have problems with the BINARY_DOUBLE type with Oracle objects.

It's very easy to reproduce the problem. Here is my SQL code:

Code: Select all

CREATE TYPE TEST AS OBJECT ( 
  IATTR INTEGER,
  VATTR VARCHAR2(80),
  TESTATTR BINARY_DOUBLE 
);
/

CREATE TABLE TEST_TABLE OF TEST;

INSERT INTO TEST_TABLE VALUES (123456, 'ABCDEFG', 12345.6789);

I have tried two select statement with TOraQuery component and tested the result in a TDBGrid.

The first query:

Code: Select all

SELECT * FROM TEST_TABLE

Will produce the following result:

Code: Select all

IATTR   VATTR    TESTATTR
123456  ABCDEFG  12345.6789

The second query:

Code: Select all

SELECT VALUE(T) FROM TEST_TABLE T

Will produce the following result:

Code: Select all

VALUE(T).IATTR  VALUE(T).VATTR  VALUE(T).TESTATTR
123456          ABCDEFG         -1.90903812731283E184

As you can see the value of INTEGER and VARCHAR2 attributes are correct, but the BINARY_DOUBLE attribute is not!

Thanks for any replay and/or any hotfix!

Regards,
Balazs

Devart Forums

Still have problem with BINARY_DOUBLE type

Still have problem with BINARY_DOUBLE type