SET_ATTRIBUTE Procedure

46.110 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 46-93 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.

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;