13.56 UPDATE_MEMBER_ATTRIBUTE Procedure Signature 5
Update the specified NUMBER member attribute in the given named collection. If a collection does not exist with the specified name for the current user in the same session for the current Application ID, an application error is raised. If the member specified by sequence ID p_seq does not exist, an application error is raised. If the attribute number specified is invalid or outside the valid range (currently only 1 through 5 for NUMBER), an error is raised.
Syntax
APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE (
p_collection_name IN VARCHAR2,
p_seq IN NUMBER,
p_attr_number IN NUMBER,
p_number_value IN NUMBER);
Parameters
Note:
Any character attribute exceeding 4,000 characters is truncated to 4,000 characters. Also, the number of members added is based on the number of elements in the first array.
Table 13-32 UPDATE_MEMBER_ATTRIBUTE Signature 5 Parameters
Parameter | Description |
---|---|
|
The name of the collection. Maximum length can be 255 bytes. Collection_names are case-insensitive, as the collection name is converted to upper case. An error is returned if this collection does not exist with the specified name of the current user and in the same session. |
|
Sequence ID of the collection member to be updated. |
|
Attribute number of the NUMBER member attribute to be updated. Valid value is 1 through 5. Any number outside of this range is ignored. |
|
Attribute value of the NUMBER member attribute to be updated. |
Example
The following example sets the first numeric attribute of collection sequence number 2 in the collection named 'Departments'
to a value of 3000.
BEGIN
APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE (
p_collection_name => 'Departments',
p_seq => 2,
p_attr_number => 1,
p_number_value => 3000);
END;
Parent topic: APEX_COLLECTION