SQL*Loader-350: Syntax error at line 1.Expecting keyword LOAD, found "ï".ï»
872638Jul 1 2011 — edited Jul 1 2011Friends,
I'm getting the below whenever i execute my control file.
"
SQL*Loader: Release 9.2.0.1.0 - Production on Thu Jun 30 14:39:01 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL*Loader-350: Syntax error at line 1.
Expecting keyword LOAD, found "ï".

^
"
Below is my control file
options(direct=false,errors=25000)
load data
append
into table tarpt_entity_filing_batch
fields terminated by '·'
(
ARPT_ENTITY_FILING_ID,
BUSINESS_TYP_C,
REPORT_TYPE_CD,
STATE_ID,
DUE_DATE DATE 'DD-Mon-YYYY hh24:mi:ss',
FILING_START_DATE DATE 'DD-Mon-YYYY hh24:mi:ss',
FILING_END_DATE DATE 'DD-Mon-YYYY hh24:mi:ss',
FILING_YEAR,
IS_FILED,
ENTITY_NAME,
DOM_JURIS_ID,
FILING_JURIS_ID,
SOURCE_TYPE_CD,
SOURCE_BUS_AUTH_ID,
HCUE_ENTITY_TYPE,
SERVICE_TYPE_ID,
ACTION_I,
CREATED_BY,
CREATED_DATE DATE 'DD-Mon-YYYY hh24:mi:ss',
LAST_MODIFIED_BY,
LAST_MODIFIED_DATE DATE 'DD-Mon-YYYY hh24:mi:ss'
)
Interestingly, when i remove the "errors"paramter in the options clause it's working fine.
PS: i'm not passing any paramaters from command line
Any help in this will be grealty appriciated
Thanks
siva