UPDATE_MEMBER_ATTRIBUTE Procedure Signature 3

Updates the specified BLOB 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 occurs.

If the member specified by sequence ID p_seq does not exist, an application error occurs.

If the attribute number specified is invalid or outside the valid range (currently only 1 for BLOB), an error occurs.

Syntax

APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE (
    p_collection_name   IN VARCHAR2,
    p_seq               IN NUMBER,
    p_blob_number       IN NUMBER,
    p_blob_value        IN BLOB )

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.

Parameter	Description
`p_collection_name`	The name of the collection. Maximum length is 255 bytes. Collection names are case-insensitive and are 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.
`p_seq`	Sequence ID of the collection member to be updated.
`p_blob_number`	Attribute number of the BLOB member attribute to be updated. Valid value is 1. Any number outside of this range is ignored.
`p_blob_value`	Attribute value of the BLOB member attribute to be updated.

Example

The following example sets the first and only BLOB attribute of collection sequence number 2 in the collection Departments to a value of the BLOB variable l_blob_content.

BEGIN
    APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE (
        p_collection_name => 'Departments',
                    p_seq => 2,
            p_blob_number => 1,
             p_blob_value => l_blob_content);
END;