Re: ORA 01401 error inserted value too large for column

In article <333981103wnr_at_rossuk.demon.co.uk> Rod Green <Rodgr_at_rossuk.demon.co.uk> writes:
> We are getting this error. I have debugged the program code but cannot
> find which column is giving the error.
>
> I tried producing a trace file to see if that helped, but it does not
> show where the error occurred, or not that I can see.

It is very likely that you are trying to insert a character string into a column which has a shorter column width than the string. Another, less common, cause is inserting a number which exceeds the declared size of the column.

If the insert statement in question uses bind variables for inserted values, check the size of the variable declarations (especially VARCHARs) and use the debugger to examine the values prior to insert. If you are using columns from other tables to do inserts, match the column widths one by one. If using PL/SQL, you should check all the variable declarations to match the column widths.

Good luck.

--
"And this is all I have to say about that..."   - F. Gump
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
|  Alvin W. Law ..... Oracle Corporation ....... Email: alaw_at_us.oracle.com  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel