1  –  cursor-name

    The name of the cursor you want to close.

2  –  cursor-name-parameter

    Use a parameter if the cursor referred to by the cursor name
    was declared at run time with an extended dynamic DECLARE CURSOR
    statement. Specify the same cursor name parameter used in the
    dynamic DECLARE CURSOR statement.

    You can use a parameter to refer to the cursor name only when the
    CLOSE statement is accessing a dynamic cursor.