Use this function to compute and return the message digest of the attributes for the member specified by the sequence ID. This computation of message digest is equal to the computation performed natively by collections. Thus, the result of this function could be compared to the
MD5_ORIGINAL column of the view apex_collections.
If a collection does not exist with the specified name for the current user in the same session and 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.
APEX_COLLECTION.GET_MEMBER_MD5 ( p_collection_name IN VARCHAR2, p_seq IN NUMBER) RETURN VARCHAR2;
Table 7-18 GET_MEMBER_MD5 Parameters
The name of the collection to add this array of members to. 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.
The following example computes the MD5 for the 5th member of the GROCERIES collection.
declare l_md5 varchar2(4000); begin l_md5 := apex_collection.get_member_md5( p_collection_name => 'GROCERIES' p_seq => 10 ); end;