SET_EMAIL Procedure

59.123 SET_EMAIL Procedure

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

Syntax

APEX_UTIL.SET_EMAIL (
    p_userid IN NUMBER,
    p_email  IN VARCHAR2 );

Parameters

SET_EMAIL Parameters

Parameter	Description
`p_userid`	The numeric ID of the user account.
`p_email`	The email address to be saved in user account.

Example

The following example shows how to use the SET_EMAIL procedure to set the value of EMAIL to "frank.scott@example.com" for the user "FRANK."

BEGIN
    APEX_UTIL.SET_EMAIL(
        p_userid  => APEX_UTIL.GET_USER_ID('FRANK'),
        p_email   => 'frank.scott@example.com');
END;