Devart Forums

Posted: **Thu 03 Dec 2020 14:17**

Hi.
Installed component: UniDAC 8.3.2 for RadStudio 10.4

How can I set a session variable NLS_NUMERIC_CHARACTERS in direct mode ?
Client OS is Windows 10 Pro Polish with regional settings for numbers: ", ".
Oracle server has NLS_NUMERIC_CHARACTERS=".,".
After connect in direct mode query result for:

"SELECT value from NLS_SESSION_PARAMETERS where parameter='NLS_NUMERIC_CHARACTERS'

is ".," insetad of ", ".

Before connecting I set:
Direct=True
UseUnicode=True
UnicodeEnviroment=True

Posted: **Sat 13 Feb 2021 20:44**

Try to use the following approach :

Code: Select all

  OraSession.ExecSQL('Alter Session Set NLS_NUMERIC_CHARACTERS = '',.''');

Devart Forums

UniDAC - Oracle - setting NLS_NUMERIC_CHARACTERS in DIRECT mode

UniDAC - Oracle - setting NLS_NUMERIC_CHARACTERS in DIRECT mode

Re: UniDAC - Oracle - setting NLS_NUMERIC_CHARACTERS in DIRECT mode