Sql*Loader not liking FILLER
Hi,
I am trying to load 2 separate tables with the following in my .ctl file:
LOAD DATA APPEND INTO TABLE rand_ap_odepot_headers WHEN tab = 'A' (tab FILLER position(1) CHAR, invoice_id "rand_ap_odepot_headers_s.nextval", summary_bill_nbr, bill_from_date "to_date(:bill_from_date, 'MM/DD/YYYY')", bill_to_date "to_date(:bill_to_date, 'MM/DD/YYYY')") INTO TABLE rand_ap_odepot_lines WHEN tab = 'B' (tab FILLER position(1) CHAR, invoice_id "rand_ap_odepot_headers_s.curval", line_nbr RECNUM, invoice_nbr FILLER, original_order FILLER, contact_name FILLER, ship_to, po_nbr,0