...
Oracle: CURSOR cursor_name IS select-statement; OPEN cursor_name
MySQL: BEGIN DECLARE my_cursor CURSOR FOR select-statement << can't be prepared statement>>; OPEN my_cursor; END
...
Oracle: CURSOR cursor_name IS select-statement; OPEN cursor_name
MySQL: BEGIN DECLARE my_cursor CURSOR FOR select-statement << can't be prepared statement>>; OPEN my_cursor; END