sqlldr problems with dates and long datatypes

From: CME <support_at_cmesys.demon.co.uk>
Date: Wed, 11 Jul 2001 08:52:35 +0100
Message-ID: <994837723.1945.0.nnrp-02.c2de4217@news.demon.co.uk>

I am trying to upload data into an oracle database using sqlldr and a comma seperated file from a sybase database
I am having two problems:
1) I can't input dates and times into the oracle date datatype. However I can get both dates and times into an oracle date datatype using DBA Studio. 2) I cannot input a very long string of charactors into a long datatype.

my control file for sqlldr looks something like this:

---

LOAD DATA
INFILE *
INTO TABLE X.TBLNAME
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'" (num,num2,lastupdate)
BEGINDATA
1,1,2001/07/04 13:36:00.801000

---

thanks for any help Received on Wed Jul 11 2001 - 02:52:35 CDT