sql loader problem

[pst]

Hi,

I 'm tried to populate an oracle table from an export I got from oracle.

My control file:
LOAD DATA
INFILE 'c:\countries.dat'
INTO TABLE countries
FIELDS TERMINATED BY ','
(country_code,
country,
currency_code,
currency_name ,
currency_symbol )

My data file:
PH,Philippines,560,Peso,
PL,Poland,378,Zloty,
PT,Portugal,269,Escudo,Esc

But when I run sqlldr, I get the following error:
Record 1: Rejected - Error on table COUNTRIES, column CURRENCY_SYMBOL.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 2: Rejected - Error on table COUNTRIES, column CURRENCY_SYMBOL.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 3: Rejected - Error on table COUNTRIES, column CURRENCY_SYMBOL.
Column not found before end of logical record (use TRAILING NULLCOLS)

Can you tell me how to solve this?

thanks a lot

pst

[kgb]

Try this

LOAD DATA
INFILE 'c:\countries.dat'
INTO TABLE countries
FIELDS TERMINATED BY ','
(country_code NULLIF country_code=BLANKS,
country NULLIF country=BLANKS,
currency_code NULLIF currency_code=BLANKS,
currency_name NULLIF currency_name =BLANKS,
currency_symbol NULLIF currency_symbol =BLANKS)

[Kumud]

add one more comma to your ist three line you have five filed and value you are entering is four

[SANJAY_G]

use TRAILING NULLCOLS.

Sanjay