8.3.5.3 Validating Submitted Data

Define validations to enforce the correctness of submitted data before saving it. You create them in the Validating execution point of the Processing tab in your page.

Validations can check the value of a single page item or test a more complex condition involving multiple values. They can consult system of records tables as needed.

For convenience, you can also create one for a particular page item by choosing Create Validation from the item's context menu in the Rendering tab. In this case, Page Designer defaults its Associated Item property as expected.

Each validation defines a condition that determines if the value or values being checked are considered valid. You can pick from a list of declarative conditions, use a PL/SQL expression or boolean returned from a PL/SQL function body, or use a SQL statement that returns a row or not. If the condition is true, the validation succeeds. If it is false, the end user sees your configured error message. If any validations fail, the user sees all of their failure messages and the APEX engine does not execute the elements in the Processing phase of the Submit lifecycle.

For more information, see Understanding Validations in Oracle APEX App Builder User’s Guide.

Tip:

To validate columns in an Interactive Grid, set the Editable Region property of the validation to the name of the related grid and then reference the grid's columns by name when defining the validity condition.