Loading records with time stamps

Hi there,

I'm trying to use sqlldr.exe to load the following row [just one sample row but I'm actually loading heaps of these]

Thu Jun 07 18:13:25 2001, 25573557, 4734374, 044628314, 10.766

into the table 'VOICE_DIAL':

SQL> DESCRIBE VOICE_DIAL

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------
 CALLDATE                                               DATE
 CALLER                                             NUMBER
 HOST                                               NUMBER
 CALLED_NUMBER                                      NUMBER
 DURATION                                           NUMBER

This is the control file:

LOAD DATA
INFILE 'H:\LOGS\VOICE_DIAL\2001_06_07_VOICE_DIAL.DAT' INTO TABLE TELCO.VOICE_DIAL
FIELDS TERMINATED BY ','
(CALLDATE, CALLER, HOST, CALLED_NUMBER, DURATION)
After invoking sqlldr, it goes:

E:\scripts>SQLLDR USERID=TIGGER/FOO_at_FOOBAR,

           CONTROL='E:\SQL\LOAD_VOICE_DIAL.CTL', 
	   DATA='H:\LOGS\VOICE_DIAL\2001_06_07_VOICE_DIAL.DAT'

SQL*Loader: Release 8.1.6.0.0 - Production on Mon Jun 11 17:34:37 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Commit point reached - logical record count 1

...
But nothing actually gets loaded and my row appears in the ".bad" file . I changed the first column to '06-JUN-01' and the row was loaded successfully.
Now how can I tell sqlldr to look at the first column as a full time-stamp and load it in that format? I need to do this because my table has to store information on both the date and time that a call was made.

environment:
Oracle 8i Release 8.1.6.0.0
Windows NT 4.0

Thanks for any tips!
- Allan Received on Mon Jun 11 2001 - 01:05:02 CDT