number(precision>28) ??
Posted: Thu 26 May 2005 21:58
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
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();