SQLLOADER PROBLEM...HELP!

From: Ranj <rbajaj_at_redl.co.uk>
Date: Fri, 7 Apr 2000 11:16:17 +0100
Message-ID: <8ckchg$jb8$1_at_rdel.co.uk>

[Quoted] Can anyone help.... .I'm using the sqlloader utility.

I'm loading ASCII data files into Oracle Database tables. The following is my control file code.

---

---

LOAD DATA INFILE FA_COMMENT.Asc
BADFILE ELT_FA_COMMENT.BAD
DISCARDFILE ELT_FA_COMMENT.DIS APPEND
CONCATENATE 4
INTO TABLE elt_text_db
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(INSERT_ID INTEGER EXTERNAL,
 ELT_TEXT LONG EXTERNAL,
 REC_TYPE CONSTANT 'FA')

---

---

[Quoted] However i get this following Error:

SQL*Loader-350: Syntax error at line 25. Expecting "," or ")", found "LONG".

 ELT_TEXT       LONG EXTERNAL,
          ^

I don't think sqlloader likes LONG's....what can i do to correct this error. [Quoted] Can i not use the LONG data type?

I would appreciate it if someone could help.

Thankyou very much in advance

Ranj Received on Fri Apr 07 2000 - 12:16:17 CEST