Previous
Previous
 
Next
Next


UPDATE_MEMBER_ATTRIBUTE Procedure Signature 6

Update the specified DATE 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 will be raised. If the member specified by sequence ID p_seq does not exist, an application error will be raised. If the attribute number specified is invalid or outside the valid range (currently only 1 through 5 for DATE), an error will be raised.

Syntax

APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE (
    p_collection_name IN VARCHAR2,
    p_seq IN VARCHAR2,
    p_attr_number IN NUMBER,
    p_number_value  IN DATE);

Parameters

Table: UPDATE_MEMBER_ATTRIBUTE Signature 5 Parameters describes the parameters available in the UPDATE_MEMBER_ATTRIBUTE procedure signature 6.


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.

UPDATE_MEMBER_ATTRIBUTE Signature 6 Parameters

Parameter Description

p_collection_name

The name of the collection. Maximum length can be 255 bytes. Collection_names are case-insensitive, as the collection name will be 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_attr_number

Attribute number of the DATE member attribute to be updated. Valid value is 1 through 5. Any number outside of this range will be ignored.

p_number_value

Attribute value of the DATE member attribute to be updated.


Example

Update the first attribute of the second collection member in collection named 'Departments', and set it to a value of 100.

BEGIN;
    APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE (
        p_collection_name =. 'Departments',
        p_seq => '2',
        p_attr_number => '1',
        p_number_value => 100 );
END;