SET_USERNAME Procedure

59.142 SET_USERNAME Procedure

Note:

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

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

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

Example

The following example shows how to use the SET_USERNAME procedure to set the value of USERNAME to 'USER-XRAY' for the user 'FRANK'.

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