43.109 SET_ATTRIBUTE Procedure
This procedure sets the value of one of the attribute values (1 through 10) of a user in the Application Express accounts table.
Syntax
APEX_UTIL.SET_ATTRIBUTE(
p_userid IN NUMBER,
p_attribute_number IN NUMBER,
p_attribute_value IN VARCHAR2);
Parameters
Table 43-93 SET_ATTRIBUTE Parameters
Parameter | Description |
---|---|
|
The numeric ID of the user account. |
|
Attribute number in the user record (1 through 10). |
|
Value of the attribute located by |
Example
The following example shows how to use the SET_ATTRIBUTE
procedure to set the number 1 attribute for user 'FRANK' with the value 'foo'.
DECLARE
VAL VARCHAR2(4000);
BEGIN
APEX_UTIL.SET_ATTRIBUTE (
p_userid => apex_util.get_user_id(p_username => 'FRANK'),
p_attribute_number => 1,
p_attribute_value => 'foo');
END;
See Also:
Parent topic: APEX_UTIL