Hi,
Is it possible to change the NLS_NUMERIC_CHARACTERS in existing session when
using OO4O 2.3.
I've tried it but to my experience it does not work. Does anybody found a
workaround for this, or suggestions what we
are doing wrong.
We use the following scenario:
- We have database table: t(n NUMBER).
- We have nls_territory: AMERICAN.AMERICA in database.
- We have decimal separator , (comma) and thousand separator (space) in
workstation (because we are silly finnishman).
- When the user logs in to oracle we retrieve from windows regional
settings the decimal and thousand separators
- With these characters we call a procedure that further calls alter
session (by DBMS_SESSION.set_nls) (this should set
the NLS_NUMERIC_CHARACTERS according our Windows regional settings, but it
seems to be not functioning)
- Now we have procedure that returns data from table t, column n in array.
- When we retrieve the value with .Parameters.getValue the number has
decimal point as . (stop), not a comma as we expected.
file://Jarmo
Received on Tue May 18 1999 - 07:16:51 CDT