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

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.

Create a validation, and at the validation level specify your tabular form and validation level as Tabular Form Row.
Specify the type as PL/SQL Expression: validate_tabular_test(:COL1, :COL2)
Specify the error message as: #LABEL# must not be greater than 5000
Give the process a condition for the submit button

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

Instructions