System.Overflowexception: Arithmetic Operation Resulted In An Overflow Using OracleCommandBuilder (Doc ID 1375572.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Microsoft Windows x64 (64-bit)

Symptoms

Using 64 bit ODP.NET with an OracleCommandBuilder may result in in a System.OverFlowException when under load.

A sample stack is as follows:

System.OverflowException: Arithmetic operation resulted in an overflow.
at Oracle.DataAccess.Client.OracleCommandBuilder.GetColMetaRef()
at Oracle.DataAccess.Client.OracleCommandBuilder.FindBaseColumnOrdinal(DataColumn col)
at Oracle.DataAccess.Client.OracleCommandBuilder.GetColumnName(DataColumn col, Boolean baseColumn, Boolean caseSensitive)
at Oracle.DataAccess.Client.OracleCommandBuilder.GetInsertCommand(DataRow row)
at Oracle.DataAccess.Client.OracleCommandBuilder.RowUpdating(Object src, OracleRowUpdatingEventArgs arg)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at Oracle.DataAccess.Client.OracleDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

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