PLSQL ? ORA-01401: inserted value too large for column

[Reddy Prakash]

How to detect column that raises this error in PLSQL ? ORA-01401: inserted value too large for column

[Reddy Prakash]

i am using oracle 9i, in which it is restricted to 'ORA-01401: inserted value too large for column' where as in orale 10g the information is provided 'ORA-12899: value too large for column "STC_USER"."DEPTTAB"."DNAME" (actual: 15,maximum: 14)'

[Wendelius]

First thing that comes in mind is that you catch the error using WHEN and the print out the values for example using DBMS_OUTPUT package.

The need to optimize rises from a bad design.My articles[^]