Re: ORA-01401 How can I determine which column causes this error?

SVS wrote:

> ORA-01401: inserted value too large for column
>
> I handle exceptions in a PLSQL procedure by printing them to a table
> and raising the error. This is the error message that is printed to
> the table by "dbms_utility.format_error_stack". I would like to see
> the column name that caused this exception. How can I do this?
>
> Oracle8i Release 8.1.7.1.1
>
> Any ideas?
>
> BB

You can't. Time to do a bit of detective work ... column by column ... though you can likely ignore any DATE, CLOB, and/or BLOB.

Sometimes this is caused by moving data that has "invisible" padding with spaces such as a CHAR(3) into a VARCHAR2(2) when everything looks like it is only 2 characters.

If you post again ... include version and edition.

Daniel Morgan Received on Thu Feb 06 2003 - 01:43:39 CET