Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader Syntax Problem
Hello All,
I'm trying to load two tables from a single delimited control file and I'm getting the following error:
SQL*Loader-350: Syntax error at line 8.
Expecting quoted string or hex identifier, found
"1".
WHEN recid = 1
^
Here's the control file contents:
LOAD DATA
INFILE *
APPEND
INTO TABLE x_headers
WHEN recid = 1
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(recid INTEGER,
order_number CHAR,
customer_id,
ship_to_id,
invoice_to_id)
INTO TABLE x_lines
WHEN recid = 2
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY
'"'
(recid POSITION(1) INTEGER,
order_number CHAR,
line_number INTEGER,
sku CHAR,
quantity INTEGER)
BEGINDATA
1,1234,4444,5555,6666 2,1234,1,"RFX-8601",10 2,1234,2,"RFZ-8401",20 2,1234,3,"RFQ-8201",5 1,9943,4444,5555,6666 2,9943,1,"RFX-8601",10 2,9943,2,"RFZ-8401",20 2,9943,3,"RFQ-8201",5
Neither table has a "recid" field. Can anyone point out what is wrong with the current syntax???
Thanks in advance,
Stephen Earl
Rockford Corporation
Received on Sun Oct 04 1998 - 23:29:06 CDT
![]() |
![]() |