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

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

column col2.
Field in data file exceeds maximum length
Table SAMP

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

E:\>type samp.ctl
options (skip =1)
load data
infile 'e:\1.csv'
Replace into table samp
fields terminated by ","
trailing nullcols
(
no,
col1 Char(100000000),
col2 Char(100000000) enclosed by '"' and '"'
)

E:\>type 1.csv
Skip_this
1,asdf,"assasadsdsdsd""sfasdfadf""sdsdsa,ssfsf"
2,sfjass,"dksadk,kd,ss""dfdfjkdjfdk""sasfjaslaljs"

E:\>sqlldr test/test control=samp.ctl

SQL*Loader: Release 10.2.0.3.0 - Production on Fri Aug 7 19:15:46 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Commit point reached - logical record count 1
Commit point reached - logical record count 2

E:\>sqlplus test/test

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Aug 7 19:15:52 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options

SQL> select * from samp;

        NO COL1         COL2
---------- ------------ ----------------------------------------
         1 asdf         assasadsdsdsd"sfasdfadf"sdsdsa,ssfsf
         2 sfjass       dksadk,kd,ss"dfdfjkdjfdk"sasfjaslaljs

SQL>

SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE	10.2.0.3.0	Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
 

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