1. API Reference
  2. APEX_INSTANCE_ADMIN
  3. REMOVE_AUTO_PROV_RESTRICTIONS Procedure

32.18 REMOVE_AUTO_PROV_RESTRICTIONS Procedure

This procedure removes 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.REMOVE_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.remove_auto_prov_restrictions (
        p_block_email_patterns => apex_t_varchar2('%@gmail.com','%@example.com') );
END;

Parent topic: APEX_INSTANCE_ADMIN