sqlldr hex numbers into raw datatypes

From: CME <support_at_cmesys.demon.co.uk>
Date: Thu, 12 Jul 2001 10:51:14 +0100
Message-ID: <994931540.23059.0.nnrp-10.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 a problem loading hex numbers into raw datatypes, I was just wondering if this can be done, and if so how.

my control file for sqlldr looks something like this:

---

LOAD DATA
INFILE *
INTO TABLE X.TBLNAME
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'" (num,num2,ahexnumber)
BEGINDATA

1,1,0x000000000000000000000000000000000000000000000000
-----------------------------

thanks very much for any help Received on Thu Jul 12 2001 - 04:51:14 CDT