sqlldr-help(controlfile)

Hi,
I created this table:

SQL> desc ae2;

 Name                            Null?    Type
 ------------------------------- -------- ----
 ERR_ID                                   NUMBER(4)
 NAME                                     VARCHAR2(30)
 ITEM_LIST                                COLUMN_OBJECT

I created type Decription AS object( err_name varchar2(5000),oct1 varchar2(5000));
and
create type column_object varray(75000) of Description; create table ae2 (err_id number(4),name varchar2(30), item_list column_object);

item_list :

               err_name   varchar2(5000),
                oct1          varchar2(5000)

I can only own row in table insert with this command:

SQL> insert into ae2
values(2,'ksdhfsdfh',column_object(item_list('lasdvh skldhjkfsdlfamdjkh','lejwqhrlwerhewkhrj')));

1 row created.

How can I insert into table with (control file);

load data
infile 'text.dat'
into table ae2
field terminated by '|'
(

  err_id number(4),
  name varchar2(30),
  item_list filler char,

  column_object
    (
      item_list

          ( err_name  varchar2(5000),
       oct1  varchar2(5000)

my be Syntax error!!!

text.dat

1 | Anna | dsaklöfjasjflkjaflsdjfskljfjs | sdöfjködfjdöfjdf | 2 | Jone | asdjfösdfjkösf090fadßafd | sdfofppdsf09ggf |

SQL*Loader: Release 8.1.5.0.0 - Production on Tue Jul 11 16:26:02 2000

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL*Loader-524: partial record found at end of datafile (ae2.ctl)

Thanks a lot in Advance.

Bob Received on Mon Jul 17 2000 - 00:00:00 CEST