If the WHERE clause uses CURRENT OF cursor-name, SQL deletes only
    the row on which the named cursor is positioned.

    The cursor must have been named previously in a DECLARE CURSOR
    statement, must be open, and must be positioned on a row. In
    addition, the FROM clause of the SELECT statement within the
    DECLARE CURSOR statement must refer to the table or view that is
    the target of the DELETE statement.