I meant:
Inv_Date "TO_DATE(TO_date(:Inv_Date,'YYYY/MM/DD
HH24:MI:SS'),'DD-MON-YY')"

Liliya

-----Original Message-----
From: Liliya Freylafet
Sent: Wednesday, December 27, 2006 10:13 AM
To: 'Dustin Hayden '; LazyDBA Discussion
Subject: RE: invalid month error?

Please try:
Inv Date "TO_DATE(TO_date(:PCH_DATE,'YYYY/MM/DD
HH24:MI:SS'),'DD-MON-YY')"

Liliya

-----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