SQL*Loader and CLOB Fields

Hi

I want to upload some data in Oracle using SQL*Loader. One column in the table is of CLOB type. The information that I have

The control file that I used is as follows:

load data infile 'datatext' "var"
into table testtextfields
fields terminated by "#"
(testkey integer, testclob RAW)

I got the error that the data length exceeded field length. I tries LONG and CLOB types but I got a syntax error.

I will appreciate any help

Thanks

Khurram

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 23:11:22 CST