Validation "Column Is NOT Zero" Honored When Entering Values of 00, 000, 0000 etc etc.
(Doc ID 2106477.1)
Last updated on FEBRUARY 18, 2021
Applies to:Oracle Application Express (APEX) - Version 5.0.2 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
*** Checked for relevance on 22-Feb-2019 ****
An item has a validation of "Column Is NOT Zero" (or "Column Is NOT NULL or Zero). This works fine when entering a value of 0 in the field and trying to apply the changes, the following error is shown to the end user
"<COL> Must Have A Value & Cannot Be ZERO"
However, if the end user enters values of 00, 000, 0000. That is a series of zeros, then on applying the changes the value is accepted and thus managing to enter erroneous values of zero. Do note, the series of zeros are shown as a single zero when the page is reloaded.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document