Computes and returns 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. The result of this function can 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 occurs.

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

Syntax

APEX_COLLECTION.GET_MEMBER_MD5 (
    p_collection_name   IN VARCHAR2,
    p_seq               IN NUMBER )
RETURN VARCHAR2;

Parameters

Example

The following example computes the MD5 for the 10th 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;