1 Reply Latest reply on Feb 8, 2013 9:57 AM by Denes Kubicek

    Number field validation

      I use Apex and Oracle Database 11gR2.
      In form a have number field - field1, without Format Mask. Field1 is field from database table (DataType - Number).

      I create validation String Comparison, Item / Column specified is numeric.
      When enter values diffrent from number (abc) I got error:
      Error     Error processing validation
      ORA-06502: PL/SQL: numeric or value error: character to number conversion error.
      The same error occurs when create validation PL/SQL-Function Returning Boolean.

      I would like to create validation that return message what field on form is wrong value eg.
      field1 has wrong value.
      Is there simple way to deny enter values diffrent from number in field1?

      Any idea.
        • 1. Re: Number field validation
          Denes Kubicek

          You can have a look at this example:


          The jQuery solution is a bit better. Still, you need to enhance your code to prevent entering "." characters more than once. However, at least it allows the numbers only and that is a good thing.

          Denes Kubicek