RE: Solved - SQLLoader and clob fields

The problem had to do with the parameters ROWS, READSIZE, and BINDSIZE. I have
no idea what exactly the problem was, and, given the chance, I'll look more closely.

For now though, I have it working.. Thanks to those who helped.

Yosi

> -----Original Message-----
> From: Shakeel Qureshi [mailto:msklq_at_yahoo.com]
> Sent: Wednesday, November 22, 2000 3:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SQLLoader and clob fields
>
>
> Hi Yosi,
>
> Just write udef char(50000) and try.
>
> Shakeel Qureshi
> squreshi_at_barpoint.com
>
> --- Yosi Greenfield <yosi_at_comhill.com> wrote:
> > All,
> >
> > How do you load a clob in sql/loader?
> >
> > I'm running sql/loader to load a three field table.
> > The table structure is:
> >
> > ucui varchar2 (8)
> > usab varchar2 (7)
> > udef clob
> >
> > The third field (udef) is a clob field. The data
> > file contains three fields per
> > line,
> > each field - including the last field on the line -
> > terminated by the delimiter
> > '|'.
> >
> > The control file is listed at bottom. It's pretty
> > vanilla, except for the field
> > definition:
> >
> > UDEF CHAR(5796) NULLIF UDEF = BLANKS
> >
> > which specifies a length, since it would otherwise
> > default to 255, and my field
> >
> > would be too long.
> >
> > The rows load without error, but the value in the
> > database is wrong. The udef
> > field
> > loaded into the database for a given record is the
> > udef for a different record.
> >
> > My guess is that the length of the control file
> > field definition is wrapping to
> > and
> > reading the next record or several records. However,
> > I am using field
> > delimiters,
> > so that shouldn't be happening. Also, the record
> > that IS being loaded (the
> > incorrect one) is not necessarily near (in the
> > datafile) the record that should
> > be
> > loaded. Lastly, the first two fields of the
> > following records are not being
> > loaded
> > into the udef field - which I would think would be
> > the case if too much data
> > is being read - only a different record's udef
> > field.
> >
> > If you've read this far - wow! Thanks for any help
> > forthcoming.
> >
> > Yosi
> >
> > Control file for above:
> >
> > LOAD DATA
> > INFILE 'm:\flatfiles\MRDEF.'
> > INSERT
> > INTO TABLE MRDEF
> > FIELDS TERMINATED BY'|'
> > (
> > UCUI CHAR NULLIF UCUI = BLANKS,
> > USAB CHAR NULLIF USAB =BLANKS,
> > UDEF CHAR(5796) NULLIF UDEF = BLANKS
> > )
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shakeel Qureshi
> INET: msklq_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Nov 22 2000 - 15:36:19 CST