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

HTMLDB_UTIL.SET_ATTRIBUTE( 
    p_userid IN NUMBER, 
    p_attribute_number IN NUMBER,
    p_attribute_value  IN VARCHAR2);

Parameters

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

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

DECLARE VAL VARCHAR2(30); 
BEGIN 
    HTMLDB_UTIL.SET_ATTRIBUTE ( 
        p_userid => htmldb_util.get_user_id(p_username => 'SCOTT'), 
        p_attribute_number => 1, 
        p_attribute_value => 'foo'); 
END;