Database Software

Hi,
How to change the NLS_NUMERIC_CHARACTERS database paramater for my SQLLDR mapping?

I have an input flat file which has numeric data with ',' as decimal separator means NLS_NUMERIC_CHARACTERS setting as ',.'
However in my target oracle schema, the decimal separator is '.' which has NLS parameter set as NLS_NUMERIC_CHARACTERS='.,'

My OWB version is 10.2.
When I checked the configuration parameters of the sql loader mapping and the flat file operator, There is facility to change language, but not NLS_NUMERIC_CHARACTERS setting.

I do not want to change the NLS_NUMERIC_CHARACTERS setting in my database as there are many other projects which will get impacted.


We got a work around as below using external table & premap procedure. But as I have many mappings already developed, It is not possible to use this workaround.

- I can use premapping procedure with external tables to populate.
- NLS_NUMERIC_CHARACTERS setting can be changed using procedure for that particular session.

Is there a way to change NLS_NUMERIC_CHARACTERS setting only for that particular mapping/mapping session?

Thanks,
SriGP