alter session
469870Oct 6 2006 — edited Oct 7 2006hello
i have an application runing an english french interface,
numbers in english use dot for decimal point ex: 123.45
if the user choose french as a language the number should display 123,56
so after some research i was directed to use
dbms_ddl('alter session set nls_numeric_characters=,.)
what is wird is that the alter session works fine within sqlplus but never within toad or form builder, there it says 'session altered' but the numbers are still displayed with a dot . as a decimal separator, while in sqlplus it works
i dont want to change the registery value each time
any help ?
thanks