Hello,
currently we are using APEX 20.1 and I ran into an error when I use this format for a number field in a form:
999G999G999G999G990D000
This leads to numbers like this:
5.000,000
I use the concerning Item in a page process where I call a procedure. The parameter for this item is a number and the APEX Item is a number as well and formated as mentioned above.
When I start the process I get this Error:
Error Stack: ORA-06502: PL/SQL: numerischer oder Wertefehler: character to number conversion error
And this only happends when the numbers are equal or bigger than 1.000. So I think the point is here the problem.
I tried this in the sample workspace of oracle for APEX 22.1 as well. The automatic process seems to work with this format, but when I want to insert the number in a query there I get the following error:
ORA-01722: invalid number
I worked the Problem around with leaving out the points but it would nicer with points :)
I think this is a bug, what do you mean? Have you any ideas for a better work around?
Regards