Apex ver 19.2
I have an Optional page item
Type: Numeric
It's my understanding per the on screen Help that numeric items will automatically be validated to be sure the value is numeric, so no additional validation should be necessary.
However, the built in validation doesn't appear to be firing until after the code in my Submit Process attempts to run. The code fails because the value in this page item is not numeric.
I tried creating my own validation but that too doesn't seem to fire. There's no inline error message like there is if you leave a required field blank. I'm only getting an error when I make my procedure call because the value in my page item is not numeric. (it can be null).
Is there a declarative way to handle this?
If I have to write an error handler, is there a way to populate the inline validation message?
In other words, how do I go about displaying error messages that are descriptive to the user and not the default
"ORA-06502: PL/SQL: numeric or value error: character to number conversion error:"
that I get because the validation doesn't work? Keep in mind there are several page items that need to be validated before saving, so at the very least I'd need a way to reference the field that needs to be corrected.