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 laterInformation 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 |