What am I doing wrong?



Trying to load this data:



Vendor,Invoice ID,Inv Date,PO ID

AAG,93828306,30-NOV-06,PH-152676

AAG,93828307,30-NOV-06,PH-153812



Ctrl file:

LOAD DATA

INFILE 'c:\edi.csv'

REPLACE

into table sysadm.edi

fields terminated by ',' optionally enclosed by '"'

trailing NULLCOLS

(vendor_id "trim(:vendor_id)",

invoice_id "TRIM(:invoice_id)",

invoice_dt "to_date(:invoice_dt,'DD-MON-YY')",

PO)





Log file:



Record 437: Rejected - Error on table SYSADM.EDI, column INVOICE_DT.

ORA-01843: not a valid month


Oracle LazyDBA home page