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