oracle 1401

[alainc]

hi all,

i get an ora 1401 which i know mean that i try to insert a too large value but how to find wich column is it i can't see it on the message. i can't try to trace my message cause it's an automatic insertion into the database and it appear not so often

thanks

Alain

[jgmagnus]

i come across this problem when using sql-loader.
you need to specify the field size on columns that have a large varchar2 or char size (i think over 200 characters or so).
If it is an automatic insertion, find your insertion script and add "char(column_width)" after the column name of the longer columns in your load/insertion script.

add the 'char(size)' to all the lengthy fields and see if that solves your problem.

- Magnus

[alainc]

it's not a script it'a a C++ software automatically inserting data all days and sometimes maybe once or twice aweek i get this message but with the error message i can't tell which column is faulty. i know that's it's not a number colum or i will get a 1438 instead of a 1401.