UniDAC - Oracle - setting NLS_NUMERIC_CHARACTERS in DIRECT mode

[gcholawa]

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

[MaximG]

Try to use the following approach :

Code: Select all

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