Hi there,

I am getting the following problem from an SQL Loader file.

This file ran correctly last year when the database was version 7.3.3, however is has since been upgraded to version 8i (running on NT)

SQL*Loader-350: Syntax error at line 14.
Expecting positive integer or column name, found keyword month.
month integer external NULLIF month=BLANKS,

The cmd file looks like:-

set ORACLE_SID=DRPL
f:\orant8i\bin\sqlldr userid=DRPL/DRPL control=f:\drpl\drplload\ctl\week_2003.ctl log=f:\drpl\drplload\log\week_2003.log

The ctl file is:-

OPTIONS ( DIRECT=TRUE )
LOAD DATA
INFILE "f:\drpl\drpldata\week2003.dat"
DISCARDFILE "f:\drpl\drplload\discard\week2003.dis"
DISCARDMAX 999
APPEND
INTO TABLE WEEK_CONVERSION
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
( year char,
start_date date(8) "YYYYMMDD",
day_number integer external,
week_number integer external,
year_week char,
month integer external NULLIF month=BLANKS,
quarter integer external NULLIF quarter=BLANKS,
last_friday_of_month char,
seq integer external)

Many thanks in advance

Allie