Re: SQL-Loader with long varchar2 fields

In article <3418FBDB.18ED_at_for-sale.de>,

        Markus Meier <Markus.Meier_at_for-sale.de> writes:
> 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 "@"
> 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

Markus,

        Could this have something to do with a column named desc?

01:02:11 SQL> create table temp ( desc varchar2 ( 1024 ) ); create table temp ( desc varchar2 ( 1024 ) ) *
ERROR at line 1:
ORA-00904: invalid column name

        desc is a reserved word, how did you create the table?

Tony

-- 
S. A. Sequeira tony_at_sequeira.powernet.co.uk