9.43 MOVE_MEMBER_DOWN Procedure

Use this procedure to adjust the sequence ID of a specified member in the given named collection down by one (subtract one), swapping sequence ID with the one it is replacing. For example, 3 becomes 2 and 2 becomes 3.

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. If the member specified by sequence ID p_seq is the lowest sequence in the collection, an application error is NOT returned.

Syntax

APEX_COLLECTION.MOVE_MEMBER_DOWN (
    p_collection_name IN VARCHAR2,
    p_seq             IN NUMBER );

Parameters

Table 9-20 MOVE_MEMBER_DOWN Parameters

Parameter	Description
p_collection_name	The name of the collection. Maximum length is 255 bytes. Collection names are not case sensitive and are converted to upper case. An error is returned if this collection does not exist with the specified name of the current user in the same session.
p_seq	Identifies the sequence number of the collection member to be moved down by one.

Example

This example shows how to move a member of the EMPLOYEES collection down one position. After executing this example, sequence ID '5' becomes sequence ID '4' and sequence ID '4' becomes sequence ID '5'.

BEGIN
    APEX_COLLECTION.MOVE_MEMBER_DOWN( 
        p_collection_name => 'EMPLOYEES',
        p_seq => '5' );
END;