Re: sqlload CTL for fixed-width VARRAY?

So, from the lack of responses, I'm guessing SQL Loader can't load arrays from fixed-width, undelimited fields...

Last week I wrote:

> We're moving from System 1032 (a wonderful database system) on a
> VAX/VMS system to Oracle 8.0.5 on an RS/6000 AIX box. We have LOTS of
> data in array fields, and for now want to keep them that way. Can
> anyone provide me with an appropriate syntax for the SQL Loader
> control file, given a fixed-width, undelimited ASCII data input file?
> For a simple example, how would one write the control file for
> something like:

> create or replace type NARRAY as varray(10) of number;
> create or replace type CARRAY as varray(10) of varchar(5);

> create table DUMMY
> (some_numbers NARRAY
> ,some_letters CARRAY
> );

> and an input file consisting of:

> 12121212121212121212the quickbrownfox jumpsover the lazy dogs back.
> 1 2 3 4 5 6 7 8 9 0abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde

> (some_numbers always being two digits, and some_letters always being
> left-justified, space-padded, 5-character text, for this example.)

> Thanks!

--
--

• Physical ========================== Virtual ======================= Kevin Cole | E-mail: kjcole_at_gallux.gallaudet.edu P.O. Box 2739 | WWW: http://www.gallaudet.edu/~kjcole/Bike/ Washington, D.C. 20013 | Voice: (202) 234-0213

  ---

  "If they give you ruled paper, write the other way."