FIND THE CORRECT OF ERROR

parvathi · Post by **parvathi** » Mon Dec 11, 2006 7:52 am

Hi all,
I have manycolumns around 200 columns imorted from the database and while running the job i get the following error
inserted value too large for a columns,row rejected

How can i know which column value is too large..??

DSguru2B · Post by **DSguru2B** » Mon Dec 11, 2006 8:02 am

I believe you will have to spot check. i bet your database is Oracle. Right... ? This has been discussed here before and i believe that spot check is the only way to tell.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 11, 2006 1:48 pm

All the column values that you tried to insert are given in the logged error message. You can inspect that to determine which of them is too large.

DSguru2B · Post by **DSguru2B** » Mon Dec 11, 2006 1:50 pm

Not with Oracle Ray. Thats why its a pain to find what column is the culprit. It becomes more and more annoying if there are hundreds of columns.