Return Multi rows by cursor

[Abdullah Alharbi]

Hi ,
I need to return multi rows by param cursor.
I write this
-------------------
DROP PROCEDURE IF EXISTS `aa`.`new`$$

CREATE PROCEDURE `afaq`.`new`(out rec cursor)
BEGIN
open rec for 'select acc_id,acc_name from ACCOUNTS ' ;
END$$

DELIMITER ;
---------------------

Return this error

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURSOR)
BEGIN
open rec for 'select acc_id,acc_name from ACCOUNTS ' ;
END' at line 1
(0 ms taken)