GET_MEMBER_MD5 Function

This function is used 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 wwv_flow_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 will be raised. If the member specified by sequence ID p_seq does not exist, an application error will be raised.

Syntax

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

Parameters

Table: GET_MEMBER_MD5 Parameters describes the parameters available in the GET_MEMBER_MD5 function.

Example

The following example computes the MD5 for the 5th member of the GROCERIES collection.

Begin
    apex_collection.delete_members( 
        p_collection_name => 'GROCERIES'
        p_attr_number     => 5,
        p_attr_value      => 'APPLE' );
    Commit;
End;