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 -> sqlload syntax: LOBFILE not recognized

sqlload syntax: LOBFILE not recognized

From: <mansikki_at_my-deja.com>
Date: Thu, 24 Feb 2000 14:11:37 GMT
Message-ID: <893e6m$ngr$1@nnrp1.deja.com>

Hello,

do you know what could be wrong:

LOAD DATA
INFILE *
INTO TABLE TEST
APPEND
FIELDS TERMINATED BY ','
( NAME CHAR,
  F LOBFILE('comicifo.doc') TERMINATED BY EOF )
BEGINDATA
comicifo.doc,comicifo.doc

> sqlload m/t1786_at_tdb load.ctl

SQL*Loader: Release 7.3.3.4.0 - Production on Thu Feb 24 14:54:24 2000

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

SQL*Loader-350: Syntax error at line 7. Expecting "," or ")", found "LOBFILE".
  F LOBFILE('comicifo.doc') TERMINATED BY EOF

The machine is OSF1 alpha, but I've got the same result on linux running Oracle 8 as well.

Do I need soem strange extra packages??

Yours,
Marko

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 24 2000 - 08:11:37 CST

Original text of this message

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