sql*ldr problem

Hi all,

I'm having a little trouble with my sql*ldr .ctl file. I'm hoping someone can help.

I get an error when I run the following file. My data file is enclosed with ' " ' (parenthesis). The script works if the data is enclosed by ' ' ' (apostrophe). If I change the 'optionally enclosed' statement to a ' " ' (the usual way), I get a data error (column insert too big). If I change the 'optionally enclosed' statement to a ' ' ' (to match the data), it fails with SQL*Loader-350: Syntax error at line 9.
Token longer than max allowable length of 258 chars

Here is most of my .ctl file.

LOAD DATA
INFILE 'jd_ips_upload.dat'
BADFILE 'jd_ips_bad.txt'
TRUNCATE
INTO TABLE stg_custom
FIELDS TERMINATED BY "|" optionally enclosed by '''
trailing nullcols
(ADD_UPDATE,CLIENT_NUMBER, etc).

I also tried optionally enclosed by 'chr(39)', but that dies too.

Let me know if I need to send you any more data. TIA for your assistance.

Thanks for the help Raj!

Jabs,

Could you write a short summary of how Raj helped solve your problem? I have a very similar problem here!

Thanks

Ez

Hi All,

Please update me on the solution to this as I am having the same issue on 3 of my CTL files... and they are all on the same line #.

Thanks,

Richard