Re: SQLLOADER - wierd result

From: Volker Pohlers <vpohlers_at_arcor.de>
Date: Wed, 07 Sep 2005 16:32:20 +0200
Message-ID: <431ef9f4$0$2113$9b4e6d93_at_newsread2.arcor-online.net>


blindsey schrieb:
> 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?
>
with simple csv files, sql loader supports only fields with a maximum [Quoted] length of 255 bytes.

You must transfer your file into fixed length format. Here you can use full 4000 characters.

Volker Received on Wed Sep 07 2005 - 16:32:20 CEST

Original text of this message