SQL Loader with long varchar2 fields

From: Markus Meier <Markus.Meier_at_for-sale.de>
Date: 1997/09/12
Message-ID: <3418FB06.285C_at_for-sale.de>#1/1

[Quoted] Hallo to everybody

I trying to load some ASCII-Data via SQL-Loader. I´m using ORACLE Server 7.3.3 on a NT 4.0.

One coloum of the table is defined as >desc varchar2(1024)< Each row of the datafile which includes character fields longer than 256 characters for the coloum desc is not loaded.

The log file contains the following message: Datensatz 1: Zurückgewiesen - Fehler bei Tabelle artikel, Spalte desc. ORA-02359: Feld in Datei hat maximale Länge überschritten

Translated:
Record 1:Rejected - Error in table artikel, Coloum desc. ORA-02359: Field in datafile has exceeded the maximum of length.

This is strange because the fields in the datafile are not longer than 780 characters and the coloum is defined as varchar2(1024).

The controlfile looks like this:
LOAD DATA

INFILE 		'c:\db-files\loads\test.txt'
BADFILE		'c:\db-files\loads\test.bad'
DISCARDFILE	'c:\db-files\loads\test.dsc'

CONTINUEIF (1)='-'
INTO TABLE artikel
FIELDS TERMINATED BY "_at_"
TRAILING NULLCOLS

( 	id sequence(max,1),
	desc nullif desc=BLANKS,
	moddat date(10) "DD.MM.YYYY",
	useddat date(10) "DD.MM.YYYY"

)

Thanks for your help Received on Fri Sep 12 1997 - 00:00:00 CEST