Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> sqlload syntax: LOBFILE not recognized
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
![]() |
![]() |