Hi,
I am using Oracle 9i. I am trying to load clobs that are embeded in my text file. The file loads fine but the clob fields are cut of at 80 characters. Does anyone know why this is or how to fix it?

create or replace table Eightychars
(
source varchar2(10),
phyla varchar2(20),
com_name varchar2(50),
lat_name varchar2(50),
accession varchar2(20),
gi_num varchar2(10),
lineage clob,
genes clob,
reference clob,
gene_number varchar2(40),
submitdate varchar2(20),
comments clob,
taxid varchar2(10),
genome varchar2(10),
d_loop varchar2(200),
gaps clob,
prot varchar2(5),
rna varchar2(5)
)

LOAD DATA INFILE *
INTO Table Eightychars
fields terminated by "," optionally enclosed '"'
(
source,
phyla,
com_name,
lat_name,
accession,
gi_num,
lineage,
genes,
reference,
gene_number,
submitdate,
comments,
taxid,
genome,
d_loop,
gaps,
prot,
rna
)