My Oracle Support Banner

ODP.NET 12.2 Bulk Copy Insert Fails With "ORA-01722: Invalid Number" (Doc ID 2723452.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

While inserting data in table through 12c ODP.NET bulk copy functionality, following error is occurring.
Error Message: "Error in row '1' column '132' ORA-01722: invalid number".

Same code was working fine in older versions of ODP.NET (11g and below)

Changes

Oracle Client /ODP.NET is upgraded from 11g to higher versions (12cR1 / 12cR2). 

Cause

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
Symptoms
Changes
Cause
Solution


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