ODP.Net Throws Exception "Arithmetic Operation Resulted in an Overflow"

(Doc ID 255476.1)

Last updated on AUGUST 30, 2010

Applies to:

Oracle Data Provider for .NET - Version: 9.2.0.2.0 and later   [Release: and later ]
Microsoft Windows (32-bit)

Symptoms

While subtracting two dates, the Oracle Data Provider for .NET (ODP.NET) receives the following error:

Unhandled Exception: System.OverflowException: Arithmetic operation resulted
in an overflow.
at Oracle.DataAccess.Types.DecimalConv.GetDecimal(IntPtr numCtx)
at Oracle.DataAccess.Client.OracleDataReader.GetDecimal(Int32 i)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms