java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01438: value larger than specified precision allows for this column

Question

I'm getting this error message in production.

Unfortunately this comes from a purchased application and the support process is not precisely fast.

This happens when data is being copied from one table to another. Both tables are supposed to have the same columns types and length. So far I have reviewed a some of them by doing the following:

select distinct( length( column_name ) ) ) from source_table

Then comparing the value with the length of column_name in the target table but it's taking me a lot of time.

Is there a better way to perform this check?

I want to identify what column contains the data whose length goes beyond the limit of the source.

I'm working with:

Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production

Answer 1

A brute force method for debugging this:

You could create a script that runs a FOR loop and inserts row by row from Table A to Table B, outputting the row ID or some pertinent data to the console. Once you identify the bad row, you could attempt to update column by column of an existing row with the column data from the bad row until you find your culprit.

Answer 2

try the below link

ORA-01438: value larger than specified precision allows for this column