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 -> Re: using sqlldr to load data into a varray

Re: using sqlldr to load data into a varray

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 18 Jan 2006 15:53:39 GMT
Message-Id: <pan.2006.01.18.15.53.39.577244@sbcglobal.net>


On Wed, 18 Jan 2006 07:12:18 -0800, Kevin wrote:

> 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."
>
> Can anyone tell my why I cant fill the table? I have following the
> article at asktom:

Kevin, I don't think that SQL*Loader is the right way to do it. I believe that you'd need something like Perl or PHP, a general purpose language that can communicate with Oracle.

-- 
http://www.mgogala.com
Received on Wed Jan 18 2006 - 09:53:39 CST

Original text of this message

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