DELETE_USER_GROUP Procedure Signature 1

59.21 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 Accounts authentication. To execute this procedure, the current user must have administrative privileges in the workspace.

Note:

This procedure operates on the native APEX user accounts repository and is only applicable to applications configured with Oracle APEX Accounts authentication.

Syntax

APEX_UTIL.DELETE_USER_GROUP (
    p_group_id  IN NUMBER );

Parameter

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;

Parent topic: APEX_UTIL