number(precision>28) ??
number(precision>28) ??
declare in Oracle number with precision bigger then 28 and fill this field with 29 or more digits - OraDirect 2.5/3.0 cant return this values properly
We cannot reproduce your problem with OraDirect .NET 3.0
Code: Select all
CREATE TABLE NUMTEST (
F1 NUMBER(30)
)
Code: Select all
oracleConnection1.Open();
oracleCommand1.CommandText = "select * from NUMTEST";
OracleDataReader reader = oracleCommand1.ExecuteReader();
reader.Read();
OracleNumber n = reader.GetOracleValue(0);
string s = n.ToString();