Re: SQLLOADER PROBLEM...HELP!

Don't know whether it is of any help but have you considered doing this all from Excel? I've developed a utility called Oraxcel that is very suitable for this kind of work and that gives decent error messages all from within Excel.

Note that flat files can reasonably easially be imported in Excel. I'm pretty sure if you create a macro for your particular flat file, parsing will be very easy indeed.

Please have a look at Oraxcel at http://www.oraxcel.com

Regards,

--
Gerrit-Jan Linker

web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE


Ranj <rbajaj_at_redl.co.uk> wrote in message news:8ckchg$jb8$1_at_rdel.co.uk...


>

> 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')

> --------------------------------------------------------------------------

--


> -----------------------------------


>

> 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.


> Can i not use the LONG data type?


>

> I would appreciate it if someone could help.

>

> Thankyou very much in advance

>

>

> Ranj

>

>

>

>