Nested Cursor in Mysql of Code Template

DECLARE c_rno INT;
DECLARE c_name VARCHAR(100);
DECLARE cursor_var CURSOR FOR SELECT rno,name FROM students;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

OPEN cursor_var;

cursor_var_loop: LOOP
FETCH cursor_var INTO c_rno,c_name;

— cursor loop statements
INNER_BLOCK: BEGIN
DECLARE inner_cursor_var CURSOR FOR SELECT id,name FROM teachers;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET inner_done = TRUE;

OPEN inner_cursor_var;

inner_cursor_var_loop: LOOP
FETCH inner_ cursor_var INTO c_inner_id,c_inner_name;

— inner cursor statements

IF inner_done THEN
LEAVE inner_cursor_var_loop;
END IF;
END LOOP inner_cursor_var_loop;

CLOSE inner_ cursor_var;
END INNER_BLOCK;

IF done THEN
LEAVE cursor_var_loop;
END IF;
END LOOP;

CLOSE cursor_var;