53.19 DELETE_USER_GROUP Procedure Signature 1

This procedure deletes a user group by providing the primary key of the group when you are using Oracle APEX authentication. To execute this procedure, the current user must have administrative privileges in the workspace.

Syntax

APEX_UTIL.DELETE_USER_GROUP (
    p_group_id  IN NUMBER );

Parameter

Table 53-17 DELETE_USER_GROUP Parameters

Parameter	Description
p_group_id	Primary key of group.

Example

The following example removes the user group called Managers by providing the user group's primary key.

DECLARE
    VAL NUMBER;
BEGIN
    VAL := APEX_UTIL.GET_GROUP_ID (
        p_group_name => 'Managers');
    APEX_UTIL.DELETE_USER_GROUP (
        p_group_id => VAL);
END;