Re: Inserting CLOB's with SQL Loader

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Mon, 01 Nov 1999 17:53:48 GMT
Message-ID: <381dd2d3.20083999_at_newshost.us.oracle.com>

You're not indicating what your input data is terminated by, so it's assuming the first CR/LF character in your data. If you add "TERMINATED BY EOF", you should be hunky-dory.

Change your control file to:

LOAD DATA
INFILE *
INTO TABLE CURRENT
APPEND
FIELDS TERMINATED BY ','
(
TITLE CHAR,
FNAME FILLER CHAR,
"DATA" LOBFILE (FNAME) TERMINATED BY EOF, ID SEQUENCE(MAX,1))
BEGINDATA
Test Title,990941450410.txt

On an additional note, be very cautious about using a table name of CURRENT. In Oracle8i, this is an invalid table name.

On Mon, 01 Nov 1999 15:26:42 GMT, mb71_at_my-deja.com wrote:

>When I try to insert CLOB's using SQL Loader the CLOB field only
>receives the first 100 bytes the the CLOB. Has anyone encountered this
>before? A sample loader file is attached.
>
>Thanks,
>Mike
>
>LOAD DATA
>INFILE *
>INTO TABLE CURRENT
>APPEND
>FIELDS TERMINATED BY ','
>(
>TITLE CHAR,
>FNAME FILLER CHAR,
>"DATA" LOBFILE (FNAME),
>ID SEQUENCE(MAX,1))
>BEGINDATA
>Test Title,990941450410.txt
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Thanks!

Joel

Joel R. Kallman Oracle Service Industries

Columbus, OH                             http://govt.us.oracle.com
jkallman_at_us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Nov 01 1999 - 18:53:48 CET