My Oracle Support Banner

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

Last updated on NOVEMBER 15, 2019

Applies to:

Oracle Data Provider for .NET - Version to [Release 10.2 to 11.1]
Microsoft Windows x64 (64-bit)


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)


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.