CODEWITHSUNDEEP
c#oracle-databasetypes
kirk.burleson
kirk.burleson

Reputation: 1251

C# and the Oracle Number Datatype

I need to read a value from an Oracle database and the field has been declared as Number(38). How can I do this in C# since the Decimal type isn't big enough?

Upvotes: 5

Views: 3001

Answers (1)

Andomar
Andomar

Reputation: 238048

You could call GetString(ordinal) on the data reader, and feed the result to System.Numerics.BigInteger.TryParse().

Or perhaps you could leave the value in the OracleDecimal datatype, like you received it from ODP.NET. OracleDecimal has functions for almost everything, including math: Mulitply, Round, Exp, and so on.

Upvotes: 2

Related Questions