APEX

Hi,
I would like to use the "." as the decimal separator and the escape character for the thousand separator with an application main language set to French.
I've implemented the following application level process:
------------
declare
BEGIN
EXECUTE IMMEDIATE
'alter session set nls_numeric_characters= ''. '' ';
END
---------------
which is triggered "before header".

I have also added a database trigger which does the same thing (in order to have consistancy for others applications like SQL*Plus)

When i do a select region on the v$nls_parameters view I got:
--------Extract------------
PARAMETER: "NLS_NUMERIC_CHARACTERS"
VALUE: ". "
--------------------
which is the expected result.

When I do a page validation process to check if the value is numerical, the application doesn't detect a numeric format if the separator submitted is a '.'

Any idea?

Thanks,

Eric.
-------------
Infos: Oracle 9.2 - HTMLDB 1.5.0