sqlload CTL for fixed-width VARRAY?

From: <sorry_at_spam.invalid>
Date: Wed, 22 Dec 1999 19:08:59 GMT
Message-ID: <fl984.497$tb.80211_at_news.wenet.net>

[ This is a repost of the following article: ]
[ From: sorry_at_no.spam.thank.you.invalid ]
[ Subject: sqlload CTL for fixed-width VARRAY? ]
[ Newsgroups: comp.databases.oracle.misc ]
[ Message-ID: <UOQ74.465$tb.75145_at_news.wenet.net> ]

Hi,

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."

Received on Wed Dec 22 1999 - 20:08:59 CET