number(precision>28) ??

number(precision>28) ??

Postby 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
expas
 
Posts: 14
Joined: Wed 11 May 2005 00:09

Postby 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();
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle