number(precision>28) ??

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
expas
Posts: 14
Joined: Wed 11 May 2005 00:09

number(precision>28) ??

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
Posts: 725
Joined: Thu 28 Oct 2004 14:06

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

Post Reply