Validation "Column Is NOT Zero" Honored When Entering Values of 00, 000, 0000 etc etc. (Doc ID 2106477.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.2 and later
Information in this document applies to any platform.

Symptoms

 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 filed 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 excepted 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.

 

Changes

None. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms