Hello

We are working on Oracle 9i database.
We have to load lots of records from an external file and one of the field contains a number of characters > 10000 .
the target table contains a long field to receive this data.

i have tried to load this records but when the number of char exceeded 4821 chars no data are visible throw a select query (with Toad Developper)

here is a sample of my CTL file
Code:
Load DATA
INFILE "/export/home/crm2adm/scripts/head.tempLIGHT3"
REPLACE INTO TABLE SW_OPPORTUNITY_LONG_WORK
fields terminated by "§" 
-- optionally enclosed by "'"
TRAILING NULLCOLS
(
SWCUSTOMERID
,SWREASONCLOSED CHAR(10005) NULLIF SWREASONCLOSED=BLANKS
Description of my table
Code:
CREATE TABLE CRMADM.SW_OPPORTUNITY_LONG_WORK
(
  SWCUSTOMERID    VARCHAR2(10 BYTE)             NOT NULL,
  SWREASONCLOSED  LONG
)
Can someone can help us ?
thanks a lot.