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}