OWB10gR1: changing NLS_NUMERIC_CHARACTERS on session level
531634Jan 19 2007 — edited Jan 25 2007Hi,
we have a german running database instance whose NLS parameters are not allowed to be modified on instance level. Now, we have got files to be loaded with decimal point (american) instead of comma. So, we're running into "invalid number" error. I can't see any way to modify the loader session on session level. When setting a Unix parameter NLS_NUMERIC_CHARACTERS before starting the command sqlldr manually in the command line it would work, but how to set this with OWB's runtime service. As far as I understand the mechanism, the whole runtime management works with the environment set on runtime service start. Is there a properties file for 10gR1 or is there another place to set the environment for runtime service ? Or is there a completely different idea to handle this situation ?
Any help appreciated
regards
Thomas