Declarative Validation (COL1 Can't be greater than 5000)

Cancel Delete Submit
2442
2443
2481
1941
2043
2261
2001
2321
2441
2501
Next
Add Row

Instructions

This tabular form prevents you saving the data using a declarative function as described on this article: http://apextips.blogspot.com.au/2012/12/tabular-form-validations-and-processes.html

  1. Create a function - this is just a basic example returning false when :COL1 is greater than 5000:
    
    create or replace function validate_tabular_test(p_num in NUMBER, p_char in VARCHAR2) return BOOLEAN
    as
    begin
        if p_num > 5000
        then
            return false
        else
            return true;
        end if;
    end validate_tabular_test.
    
    
  2. Create a validation, and at the validation level specify your tabular form and validation level as Tabular Form Row.
  3. Specify the type as PL/SQL Expression: validate_tabular_test(:COL1, :COL2)
  4. Specify the error message as: #LABEL# must not be greater than 5000
  5. Give the process a condition for the submit button