C # and Oracle Datatype

Question

I need to read a value from an Oracle database, and the field was declared as Number (38). How can I do this in C # since the Decimal type is not large enough?

Answer 1

You can call GetString(ordinal)in the data reader and submit the result to System.Numerics.BigInteger.TryParse().

Or, perhaps you can leave the value in the type OracleDecimal, for example, you got it from ODP.NET. OracleDecimalIt has functions for almost all, including mathematics : Mulitply, Round, Expetc.