26.2 ADD_AUTO_PROV_RESTRICTIONS Procedure

This procedure adds blocking email patterns when an instance has auto-provisioning or self-provisioning enabled for workspaces.

If auto/self-provisioning is disabled, this procedure has no runtime effect.

Syntax

APEX_INSTANCE_ADMIN.ADD_AUTO_PROV_RESTRICTIONS (
    p_block_email_patterns IN wwv_flow_t_varchar2 DEFAULT NULL )

Parameters

Parameter Description
p_block_email_patterns Add one or more email patterns to be removed from the wwv_flow_prov_email_pattern table.

Example

BEGIN
    apex_instance_admin.add_auto_prov_restrictions (
        p_block_email_patterns => apex_t_varchar2('%@gmail.com','%@foo.com') );
END;