Skip to main content

Live demo

You can play with the plug-in without installing it using the sample application available online.

The sample application enables you to learn about the plug-in capabilities, Oracle APEX APEX integration, and simple examples of how to use the United Codes Automatic Constraint Validation plug-in.

The plug-in sample application can be downloaded and installed in your APEX scheme for free.

The plug-in sample application is one way to install the plug-in. Learn more in the section Getting Started \ Installation.

image-20230303135652378

Sample Application​

The plug-in is delivered with a sample application that describes all of the features of UC Constraint Validation with example implementations. The sample application describes and implements the following topics:

The Basics​

The basics describe how the plug-in works, how the plug-in events can be used, and allow live testing of the plug-in’s core functionality - evaluating native Oracle DML validations and validation conditions for database constraints with a client-server-process.

  • Flow
  • Validations
  • Conditions
  • Events
  • Translations

Plug-in Attributes​

The plug-in attributes pages describes and shows example implementations of each of the plug-in attributes.

  • Table Owner & Name
  • Check data types of base table columns
  • Minimum & Maximum Year
  • Notification
  • Refresh Cache
  • Wait for Results
  • Stop on Error

Triggering Element​

The triggering element pages describe the supported combinations of form events and triggering elements.

  • Event
  • Selection Type

Validation on Submit​

The plug-ins PL/SQL library provides the procedure UC_Constraint_Validation.validate_form_submit_process for validation on submit of a DML-Form. This method produces no extra network traffic but provides a simple interface for whole form validation with inline messages for associated items. Learn about

  • Procedure Prototype
  • Implementation