long-field import with sql-loader

hi,

i am trying to import long-fields of a file into a table with long fields:

here is the example:

import-file
1|...here more than 2000 char...
2|...here more than 2000 char too ...

... with the controlfile:

LOAD DATA
INFILE 'testimp.txt'
INTO TABLE test
FIELDS TERMINATED BY '|'
(

testpk,
testlong raw (10000)
)

... the table:

create table test
(

testpk number,
testlong long
)
Tablespace ts_data;

but i get in the sql-loader-log-file:

...
Record 1: Rejected - Error on table TEST. ORA-01461: can bind a LONG value only for insert into a LONG column ...

please help and thanx
R.J. Schulz Received on Wed May 12 1999 - 06:49:45 CDT