I've got a question about decimal separators in an Oracle session. I'm trying to change the separator so that it uses the same as current Windows localisation setting.
For example, I've tried it with this command:
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ", ";
This should change the decimal separator to a comma and thousand separator to a space. Works fine when I type that in SQL*Plus, but not when I use it over OO4O. So the question is, does Oracle somehow understand OO4O session differently than an SQL*Plus session? And if it does, how do I change the separator?