Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OWB10gR1: changing NLS_NUMERIC_CHARACTERS on session level

531634Jan 19 2007 — edited Jan 25 2007
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2007
Added on Jan 19 2007
3 comments
358 views