Re: SQLLDR Import of Flat files. How to handle Null fields properly

rewrite like this:

LOAD DATA
INFILE site_list3.txt
into TABLE TABLE_IMP_TEST
TRAILING NULLCOLS # this is what you are missing FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (OBJID INTEGER,
ORACLE_REF CHAR NULLIF ORACLE_REF = BLANKS, ACCOUNT_NAME CHAR NULLIF ACCOUNT_NAME=BLANKS, ORG_ID CHAR NULLIF ORG_ID=BLANKS,

SITE_ID INTEGER NULLIF SITE_ID=BLANKS,
SITE_NAME CHAR NULLIF SITE_NAME=BLANKS,
SHIP_REF CHAR NULLIF SHIP_REF=BLANKS,
BILL_REF CHAR)

<snipped>
>
> Record 11: Rejected - Error on table TABLE_IMP_TEST, column BILL_REF.
> Column not found before end of logical record (use TRAILING NULLCOLS)

                                                 ^^^^^^^^^^^^^^^^^^^^^

You are given the answer right there...

Cheers,

Bricklen Received on Mon May 20 2002 - 19:13:24 CEST