Hello all
I am doing a bulk load using a pipe delimited flat file. Following is my control file content:

Code:
LOAD DATA
INFILE '/home/oracle/Load/data1.txt'
INTO TABLE MSGEM
FIELDS TERMINATED BY '|' optionally enclosed by "'" TRAILING NULLCOLS
(
 PC, NAME, MSG1,MSG2, EMNO, CDE94, USP, NARCD, ASPCD, MNOS
)
I am getting problem here in loading texts with quotes.
E.g., Oracle's, Drug's etc.

Could somebody explain how can I escape these quotes in my data file as it is throwing out error for all the records with quotes.

Also I tried with External Table option. It throws following error message.

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-30653: reject limit reached
ORA-06512: at "SYS.ORACLE_LOADER", line 52

I think it has to do with the same issue.

Thanks in advance.
gtcol