LRM-00112: multiple values not allowed for parameter 'control' - SQL Loader
600711Jan 12 2011 — edited Jan 12 2011Hi,
Please can someone help me identify why the below SQL* Loader test doesn't work and i get the error in the subject header?
ctl file (load.ctl)
load data
infile 'C:\Documents and Settings\My Documents\loader\TEST.csv'
into table XXCPP.SQL_LOADER_TEST
fields terminated by "," optionally enclosed by '"'
( PERSON_ID, EMP_NAME, EMP_NUMBER )
command line prompt
sqlldr thompsos/generate control='C:\Documents and Settings\My Documents\loader\load.ctl' log='C:\Documents and Settings\My Documents\loader\load.log'
I'm obviously missing a key piece of code, but can't locate it?
Many Thanks