44.102 REMOVE_USER Procedure Signature 2

This procedure removes the user account identified by the user name. To execute this procedure, the current user must have administrative privilege in the workspace.

Syntax

APEX_UTIL.REMOVE_USER (
    p_user_name IN VARCHAR2);

Parameters

Table 44-85 REMOVE_USER Parameters

Parameter	Description
p_user_name	The user name of the user account.

Example

The following examples show how to use the REMOVE_USER procedure to remove a user account by user name using the p_user_name parameter.

BEGIN
   FOR i in 1..10 LOOP
      wwv_flow_fnd_user_api.remove_fnd_user(
         p_user_name => 'USER_'||i);
   END LOOP;
   COMMIT;
END;