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

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

Postby expas » Tue 14 Jun 2005 04:31

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
expas
 
Posts: 14
Joined: Wed 11 May 2005 00:09

Postby Oleg » Fri 17 Jun 2005 13:25

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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for Oracle