Hello,
I have a problem that I can't solve in my application.
- Oracle 18 XE, APEX 19.2
- database parameters are English ones
- session parameters are French ones
Issue :
The end-user enters a number in a page item (number field). The page item is not linked with any database column. The value is just stored to be used in a plugin afterwards (Apex office print - AOP).
I use a number field because, while being passed to the plugin, it is formatted with to_char.
Page item format is : 999G999G999G999G990D00.
The end-user, being French, types the number in the field item with , as decimal separator.
But then he gets :
- ORA-19202: Error occurred in XML processing
- ORA-01722: invalid number
If he uses . as decimal separator, there is no problem, number is recognized as it is and formatting is correct when using AOP.
But this is not convenient for a French user.
How can I make Apex recognize , as decimal separator when the users types the number in the field ?
Another possibility is to use a text field instead of a number field. But then how can I format correctly the string when passing it to AOP ?
Thanks ! I'm getting confused with this format issues.