Hi all,

I am trying to insert data in comma delimited file into Oracle database sitting in Unix server. After I ran the script, I got error message as,

Ora8_Acct: sqlload scott/tigger /export/home/dbase/cat.ctl

SQL*Loader: Release 8.0.4.0.0 - Production on Wed Apr 25 13:30:44 2001

(c) Copyright 1997 Oracle Corporation. All rights reserved.

SQL*Loader-930: Error parsing insert statement for column CATEG.CDATE.
ORA-00984: column not allowed here


Control file - cat.ctl

load data
infile '/export/home/dbase/cat.dat'
append
into table categ
fields terminated by "," optionally enclosed by '"'
(cat_id,lis_id,catnme,desct,ptid,stname,mdate "MM/DD/YY",
ordpt,cdate "MM/DD/YY")


Data File - cat.dat

"1","1","Antennas/Base Station Equipment","","","ACTIVE","2/2/01","1","1/18/01"
"2","1","Cable","","","ACTIVE","1/24/01","1","1/18/01"
"3","1","Call and Voice Equipment and Systems","","","ACTIVE","1/24/01","1","1/18/01"



I looked up the error codes, and check the data structure, still couldn't resolve it. Can anyone give me suggestions?

Thanks