Re: SQLLOADER - wierd result

blindsey wrote:
> I'm getting a weird error from SQLLOADER. It's rejecting records due
> 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?

Have you verified that each line ends with a CR/LF?

Try also using the TRUNC function in your SQL*Loader control file.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)