sqlldr load numbers changing decimal

Hello,

I am trying to load a text file with numbers containing a . as a decimal. The only problem is only comma , is accepted as a decimal on my server.

1;0;0;2004-02-27 00:00:00;3;0;N;;2004-02-27 00:00:00;; 1;1990;2;2003-01-09 00:00:00;5;0;N;1513.2527515762899;;;

my ctl:
LOAD DATA
INFILE 'D:\fnbhistoho.txt'
INTO TABLE "USER"."FINANCIALNUMBERHISTOHOLLOW" FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (FINANCIAL_NUMBER_SET_ID, FISCAL_YEAR, PERIOD_TYPE_ID, DATE_ORA DATE "YYYY-MM-DD HH24:MI:SS", NUMBER_TYPE_ID, IS_WIP, IS_ESTIMATED, NUMBER_VALUE, NUMBER_DATE_VALUE DATE "YYYY-MM-DD HH24:MI:SS", NUMBER_STRING_VALUE, NUMBER_INT_VALUE ) the command line:
sqlldr user/pass_at_server control=D:\testrun.ctl log=D:\log.txt

If anyone could help...
thanks in advance Received on Thu Nov 18 2004 - 09:47:31 CST