Re: Problem inserting CLOB with SQL*Loader

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 21 Oct 1999 08:18:29 -0400
Message-ID: <dwQPOMjoAe4K=f3JgzLIlLPGQ7Vo@4ax.com>

A copy of this was sent to mb71_at_my-deja.com (if that email address didn't require changing) On Wed, 20 Oct 1999 19:53:41 GMT, you wrote:

>When trying to insert a CLOb using the Oracle case studies, I receive
>the following error. Can anyone assist with what is wrong? The control
>file is listed below as well.
>

you are using Oracle8i release 8.1 syntax (filler and such) with the 8.0 sqlldr. Use the 8.1.5 SQLLDR, not 8.0.

>Thanks,
>Mike
>
>SQL*Loader: Release 8.0.5.0.0 - Production on Wed Oct 20 14:31:21 1999
>
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>
>SQL*Loader-350: Syntax error at line 8.
>Expecting "," or ")", found "FILLER".
>FNAME FILLER CHAR,
> ^
>
>title.ctl
>------------
>LOAD DATA
>INFILE *
>INTO TABLE CDATA
>APPEND
>FIELDS TERMINATED BY ','
>( CID INTEGER EXTERNAL,
>TITLE CHAR,
>FNAME FILLER CHAR,
>"DATA" LOBFILE(FNAME) TERMINIATED BY EOF)
>BEGINDATA
>content_numbering.nextval,Test Title,990941450410.txt
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Oct 21 1999 - 07:18:29 CDT