Problem with DBMS_SESSION.SET_NLS

Hi there!

In SQL*Plus the following statement is ok:

alter session set NLS_NUMERIC_CHARACTERS = '.,'

I want to set this value at runtime with the package procedure DBMS_SESSION.SET_NLS: BEGIN
  DBMS_SESSION.SET_NLS('NLS_NUMERIC_CHARACTERS', '.,'); END; But the following error occurs:

ORA-12705: invalid or unknown NLS parameter value specified

Any ideas?

Thank in advance.

Henrik Bachmann

B.I.M.-Consulting Magdeburg        http://www.bim-consulting.de/

D-39124 Magdeburg