oradirect3 (for 1.1) bug3 : number(38) cut off

[expas]

we have such table:

Code: Select all

create table t_testnumber
(
  NUM_3535 NUMBER(38,18),
  NUM_35 NUMBER(38)
)

with such values:

Code: Select all

insert into t_testnumber
values (12345678901234567890.123456789012345678, 12345678901234567890123456789012345678)

dotnet code:

Code: Select all

OracleCommand cmd = new OracleCommand("select * from t_testnumber", (OracleConnection)_cnn);
OracleDataReader reader = cmd.ExecuteReader(); 
reader.Read();
OracleNumber n0 = (OracleNumber)reader.GetOracleValue(0);
OracleNumber n1 = (OracleNumber)reader.GetOracleValue(1); 
string s0 = n0.ToString(); //"12345678901234600000"
string s1 = n1.ToString(); //"1234567890123460000000000"

instead of 12345678901234567890.123456789012345678 we receive: 12345678901234600000
and
instead of 12345678901234567890123456789012345678 we receive: 1234567890123460000000000

[Oleg]

We reproduced your problems and now we are working on solving them.
These fixes will be included in the next build that will be in a week.
Please see announcements at the forum to get know when a new build is released.