sql*loader and Date

From: swaxolez <willem_at_pcfish.ca>
Date: 18 May 2006 19:26:51 -0700
Message-ID: <1148005611.878069.274720@u72g2000cwu.googlegroups.com>

I'm trying to load a csv file into a table and keep having the following error pop up:

Record 1: Rejected - Error on table HYDDATA, column Cr_DATE. ORA-01847: day of month must be between 1 and last day of month

My Control File is:

LOAD DATA
INFILE A2.CSV
TRUNCATE
CONTINUEIF NEXT(1:1) = '#'
INTO TABLE HYDDATA
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (
  Cr_Date DATE (10) "DD/MM/YY",
  Cr_Time,
  PSI,
    GEOMETRY COLUMN OBJECT
   (

     SDO_POINT COLUMN OBJECT
       (X            FLOAT EXTERNAL,
        Y            FLOAT EXTERNAL)

   ),
   Longitude,
   Latitude,
  Heading,
  Speed,
  Mode,
  Action,
  ID

)

and my input data is of the following format:

30/04/2006,16:01:54,806,-121.6359816,34.4566166,157.1,0,0,0,1

Any help would be greatly appreciated.

Thanks Received on Thu May 18 2006 - 21:26:51 CDT