44.116 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 44-99 SET_EMAIL Parameters
Parameter | Description |
---|---|
|
The numeric ID of the user account. |
|
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@somewhere.com' for the user 'FRANK'.
BEGIN
APEX_UTIL.SET_EMAIL(
p_userid => APEX_UTIL.GET_USER_ID('FRANK'),
p_email => 'frank.scott@somewhere.com');
END;
See Also:
Parent topic: APEX_UTIL