SQL & PL/SQL

Hi,

I am having problem in loading data for tables having clob column.


Could anyone help me in correcting the below script for ctrl file inorder to load the data which is in mentioned format.

Any help really appreciated.

Table Script
------------

Create table samp
(
no number,
col1 clob,
col2 clob
);


Ctrl File
---------
options (skip =1)
load data
infile 'c:\1.csv' 
Replace into table samp
fields terminated by "," 
trailing nullcols
(
no,
col1 Char(100000000) ,
col2 Char(100000000) enclosed by '"' and '"'
)

Data File(1.csv)
----------------
1,asdf,"assasadsdsdsd""sfasdfadf""sdsdsa,ssfsf"
2,sfjass,"dksadk,kd,ss""dfdfjkdjfdk""sasfjaslaljs"


Error Encountered
-----------------
ORA-01461: can bind a LONG value only for insert into a LONG column


Table samp

Thanks in advance