SET_USERNAME Procedure

This procedure updates a user account with a new USER_NAME value. To execute this procedure, the current user must have administrative privileges in the workspace.

Syntax

APEX_UTIL.SET_USERNAME(
    p_userid   IN NUMBER,
    p_username   IN VARCHAR2);

Parameters

Table: SET_USERNAME Parameters describes the parameters available in the SET_USERNAME procedure.

SET_USERNAME Parameters

Parameter	Description
`p_userid`	The numeric ID of the user account
`p_username`	`USER_NAME` value to be saved in the user account

Example

BEGIN     
APEX_UTIL.SET_USERNAME(
    p_userid       => '888883232',
    P_username   => 'USER-XRAY');
END;