debugging ora 1401 inserted value too large

[Knarayan]

I have a table with 158 columns, Now an insert statement to this table inside a procedure fails with ora 1401 inserted value too large for column, is there an easier way to find out which column it is failing instead of having to go to one by one column to find out which value is larger than the specified length of the column in the table.

Please help if you have any suggestions..

[stecal]

If you can get your insert statement(s) separated (insert into table_name values (.....), put the data into an array (you're using PL/SQL to do this). Insert each column element one at a time, and output the success or failure of each column name/data element. Upon failure, handled with an exception, you'll know which column is causing the problem.