Ok I figured out what the problem is.

It's me!

Thanks anyway.

-----Original Message-----
From: Dustin Hayden
[mailto:oracledba-ezmlmshield-x58321700.[Email address protected]
Sent: Wednesday, December 27, 2006 10:01 AM
To: LazyDBA Discussion
Subject: invalid month error?

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



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page