Dustin,
What did you do?





Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




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

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




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