Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> using sqlldr to load data into a varray
OK, I have a table that contains a varray. I have some data and I
would like to load into it using sqlldr.
However I keep getting the error:
"direct path loading of datatype for column COL_KEVIN not supported."
This is what I have:
My VARRAY:
create or replace type type_kevin as VARRAY (2) of NUMBER(5,3);
My table:
create table TABLE_TEST
(
COL_KEVIN TYPE_KEVIN
)
My data file called test.csv:
2,1.5,1.7
My Control File:
LOAD DATA
INFILE test.csv
INTO TABLE table_test
APPEND
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
cnt filler char,
col_kevin varray count(cnt)
(
col_kevin char
)
)
Can anyone tell my why I cant fill the table? I have following the
article at asktom:
http://asktom.oracle.com/pls/ask/f?p=4950:8:9332034256132995716::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:243414670705
Help!
Thanks
Kevin
Received on Wed Jan 18 2006 - 09:12:18 CST
![]() |
![]() |