number(precision>28) ??

expas · Post by **expas** » 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

Paul · Post by **Paul** » Fri 27 May 2005 07:50

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();