CREATE PROCEDURE CleanUp(IN IN_NameArray VARCHAR(8192),
                        IN IN_commitcount integer)
    modifies sql data
    not deterministic
    language sql
BEGIN
    declare sqlcode integer default 0;
    declare mysqlcode int;
    declare VAR_name varchar(255);
    declare deletedcount integer;    
 
    declare CURSOR_name cursor with hold for
         with t2(ordinal, indx) as 
            (values ( 0, 0 ) 
            union all 
            select ordinal+1, coalesce(nullif(locate(',', IN_NameArray, indx+1), 0),length(IN_NameArray)+1) 
                from t2 where ordinal < 10000 and locate(',', IN_NameArray, indx+1) <> 0 ),
        t(ordinal, indx) as        
            (select max(ordinal)+1, length(IN_NameArray)+1 from t2
            union all 
            select ordinal, indx from t2 ),
        mytable(elems) as
            (select substr(IN_NameArray, t1.indx+1, t.indx - t1.indx - 1) from t as t1 join t as t on t.ordinal = t1.ordinal+1)
        select elems from mytable;
 
    open CURSOR_name;
    set mysqlcode = sqlcode;
 
    set deletedcount = 0;
    while ( mysqlcode = 0 ) do
        fetch CURSOR_name into VAR_name;
        set mysqlcode = sqlcode;
        if mysqlcode <> 100 then
            DELETE FROM MyTable WHERE name = VAR_name;    
            set deletedcount = deletedcount + 1; 
            if deletedcount = IN_commitcount then
                commit;
                set deletedcount = 0; 
            end if;
        end if;
    end while;
 
    commit;
 
    close CURSOR_name;    
END
;