Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> using sqlldr to load data into a varray

using sqlldr to load data into a varray

From: Kevin <kevinherring_at_lycos.co.uk>
Date: 18 Jan 2006 07:12:18 -0800
Message-ID: <1137597138.712954.222830@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US