Hello,
i need to let the user specify the decimal separator and thousands separator in my app.
I've created a Process in the Before Regions area with the PL/SQL that makes
execute immediate 'alter session set NLS_NUMERIC_CHARACTERS .... and it works fine when the Grid is shown; the problem is that if i push a button that has a dynamic action with the Grid Refresh, Apex shows the numbers field with the default separators instead of those specified in the alter session.
I've tried to re-specify the alter session set NLS_NUMERIC_CHARACTERS in "Before Refresh" it has not effect.
Can anoyne help me to understand how to correctly refresh the region with the separators?
Thanks and greetings