sql*loader limitations

hello ,
is there a limit in sql loader with 256 characters ?
How to load a field greater than 256 char ?

thanks

Hi, 25th May 2001 21:50 hrs chennai

Limitation Condition==>Yes

http://www.csee.umbc.edu/help/oracle...28_01/ch04.htm

Investigation under progress

Cheers

Padmam

Hi

There is no limit on sql loader with 256 characters but only thing is you have to use the following option in control file

I have put a small example for you

OPTIONS (BINDSIZE=236441)
LOAD DATA
INFILE 'temp.dat'
INTO TABLE temp
FIELDS TERMINATED BY ','
(
fiend1 char(300)
)

Regards