Hi
We have been facing an issue as soon as we have upgraded our DB from 11gR1 to 11gR2.
we are getting a SQL exception ORA-01403 when we tried to insert rows more than
4294967296 (which is 2 pow 32).
this is happening only when we are trying to load data to tables from JDBC drivers from application. However the data is actually gets loaded to the table but, the driver is throwing this error message after data is loaded.
Here are the DB and version information where this issue is happening:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production.
My initial guess is the return type of the driver is not sufficient enough to hold the number of records inserted if it is more than 2 pow 32.
Please let us know if it is known bug and work around if there are any