Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Loader - ORA-01840: input value not long...

H.OJun 15 2009 — edited Apr 13 2012
Hi,
I am trying to load the records from a flat file. The row with expected_receipt_date column being not null is not being inserted. Plz help
OPTIONS (SKIP = 1)
LOAD DATA
INFILE 'C:\interface\data_file.CSV'
BADFILE 'C:\interface\ctrlfile.BAD'
DISCARDFILE 'C:\interface\ctrlfile.DSC'
INSERT INTO A
Fields terminated by "," Optionally enclosed by '"'
TRAILING NULLCOLS
(
  VENDOR_ID		                     INTEGER
 ,SHIP_TO_ORGANIZATION_ID	                INTEGER
 ,EXPECTED_RECEIPT_DATE                        DATE "MM/DD/YYYY" NULLIF (EXPECTED_RECEIPT_DATE="NULL")
 ,VALIDATION_FLAG		               CONSTANT "Y"
)


_VALUES IN data_file.CSV_

VENDOR_ID	TO_ORGANIZATION_ID	EXPECTED_RECEIPT_DATE
12266	                0	                               11/30/2007
12266	                0	                               NULL
12266	                0	                               NULL
12266	                0	                               NULL


_ERROR_

Record 1: Rejected - Error on table RCV_HEADERS_INT_TEMP, column EXPECTED_RECEIPT_DATE.
ORA-01840: input value not long enough for date format

{code}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2012
Added on Jun 15 2009
24 comments
11,696 views