Cursor in Mysql

DROP procedure IF EXISTS cur_movie;
 
delimiter //
 
 
CREATE procedure cur_movie()
begin
        declare mname varchar(100);
        declare yr int;
        declare flag int DEFAULT 0;
        declare c cursor FOR SELECT movie_name,release_year FROM movie;
        declare exit handler FOR NOT found SET flag=1;
        open c;
 
        fetch c INTO mname, yr;
 
        loop
                SELECT mname AS MovieName ,yr AS ReleaseYear;
                fetch c INTO mname,yr;
 
        end loop;
        close c;
 
end //
delimiter ;