Lets say I have a table where the columns are varchar2 and number. My users want to see number formatting on all numbers and currency formatting on all currency. So I create a form to show all of the table columns. If I change the value of one item (varchar2 or number) and attempt to Apply Changes, I will get an error because one or more of the numeric items contains non-numeric value, i.e., commas and $ signs. In Oracle Forms, this was not a problem because the number formatting was recognized as formatting, but in APEX this distinction is apparently not made.
How can this be handled?
I have created javascript which either formats or unformats numbers when the mouse cursor enters or leaves the region in which the "Apply Changes" button is located. But this is a cumbersome process. Please help.