Value "4,38" of type "string" is not suitable for value type "Numeric (float)"

[Eliafont]

I'm monitoring an Oracle Database by applying the Template Oracle by ODBC.

Searching on the forum the problem seems to be on the NLS_NUMERIC_CHARACTERS parameter conifiguration:

select value
from nls_session_parameters
where parameter = 'NLS_NUMERIC_CHARACTERS';

VALUE
----------------------------------------------------------------
,.

Unfortunatelly I'm not able to change permanently the parameter.

I also see that a possible way to adjust this problem is by using a preprocessing and replace "." with "," and viceversa.
However i'm looking for a more robust and modular solution.
I tried to modify just the current session by adding this command inside the SQL query template

 ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,';

but i get the following error message:
Cannot execute ODBC query: [SQL_ERROR]:[HY000][922][[Oracle][ODBC][Ora]ORA-00922: opzione mancante o non valida]

Is there a way in zabbix I can modify this parameter without changing it permanently?

Thanks for help.
Regards.

[Eliafont]

I solved the issue by creating the following trigger:

CREATE OR REPLACE TRIGGER set_nls_on_logon
AFTER LOGON ON DATABASE WHEN (user='C##ZABBIX')
BEGIN
 EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ''.,''';
END; /

[Eliafont]

I solved the issue by creating the following trigger:

CREATE OR REPLACE TRIGGER set_nls_on_logon
AFTER LOGON ON DATABASE WHEN (user='C##ZABBIX')
BEGIN
 EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ''.,''';
END; /