58.113 SET_ATTRIBUTE Procedure
This procedure sets the value of one of the attribute values (1 through 10) of a user in the Oracle APEX accounts table.
Syntax
APEX_UTIL.SET_ATTRIBUTE (
p_userid IN NUMBER,
p_attribute_number IN NUMBER,
p_attribute_value IN VARCHAR2 );
Parameters
Table 58-80 SET_ATTRIBUTE Parameters
Parameter | Description |
---|---|
p_userid |
The numeric ID of the user account. |
p_attribute_number |
Attribute number in the user record (1 through 10). |
p_attribute_value |
Value of the attribute located by p_attribute_number to be set in the user record.
|
Example
The following example sets the number 1 attribute for user FRANK
with the value foo
.
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:
GET_ATTRIBUTE FunctionParent topic: APEX_UTIL