Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem inserting CLOB with SQL*Loader

Problem inserting CLOB with SQL*Loader

From: <mb71_at_my-deja.com>
Date: Wed, 20 Oct 1999 19:53:41 GMT
Message-ID: <7ul6ju$leu$1@nnrp1.deja.com>


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.

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. Received on Wed Oct 20 1999 - 14:53:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US