how to handle comma (,) in external tables

[zulu99]

Hi All

Currently we are using external tables. The code is like this

create table external_table
(EMPNO NUMBER(4) ,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),
DEPTNO NUMBER(2)
)
ORGANIZATION EXTERNAL
( type oracle_loader
default directory data_dir
access parameters
( fields terminated by ',' )
location ('emp.dat')
)

So this will take a comma as a field terminator. But in some rare cases i am also getting teh data with commas causing the initial load to fail.

How do i take care of such a scenario

bye

[slimdave]

no double-quotes wrapping the text? You need to get a new source file.