oradirect3 (for 1.1) bug3 : number(38) cut off
Posted: Tue 14 Jun 2005 04:31
we have such table:
with such values:
dotnet code:
instead of 12345678901234567890.123456789012345678 we receive: 12345678901234600000
and
instead of 12345678901234567890123456789012345678 we receive: 1234567890123460000000000
Code: Select all
create table t_testnumber
(
NUM_3535 NUMBER(38,18),
NUM_35 NUMBER(38)
)Code: Select all
insert into t_testnumber
values (12345678901234567890.123456789012345678, 12345678901234567890123456789012345678)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"and
instead of 12345678901234567890123456789012345678 we receive: 1234567890123460000000000