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

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

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

BEGIN
APEX_UTIL.SET_EMAIL(
    p_userid  => '888883232',
    P_email   => 'frank.scott@oracle.com');
END;