SQLLOADER - wierd result

From: blindsey <blindsey_at_dsicdi.com>
Date: 6 Sep 2005 12:50:25 -0700
Message-ID: <1126036225.555185.281450_at_g47g2000cwa.googlegroups.com>

[Quoted] [Quoted] I'm getting a weird error from SQLLOADER. It's rejecting records due [Quoted] to a field being too long. The field is VARCHAR2(4000). This is a comma-delimited file.

I've looked at the .BAD file and the fields in question are nowhere near 4000 bytes. In fact the whole .BAD file, with four rejected records, is only 3800 bytes long.

The common denominator is that each rejected field has a long string of blanks. I thought that maybe a string a CRLFs or TABs might be interpreted as longer than one charater, but I checked using a hex editor and these are indeed blanks (hex 20).

Anyone have any ideas? Received on Tue Sep 06 2005 - 21:50:25 CEST