MySQL Forums :: Cursors :: Using Cursors

CREATE PROCEDURE proc1()
BEGIN
declare sid varchar(15);
declare sname varchar(30);
declare test booloean default FALSE;
DECLARE sn CURSOR FOR SELECT SiteId,SiteName from tableA;

declare continue handler for not found
set test:=TRUE;

open sn;
repeat
fetch sn into sid,sname
if not test then
update tableB set sitename=sname where siteid=sid;
end if;
until test
end repeat;
CLOSE sn;
END;


The error message is :
ERROR 1064: You have an error in your SQL syntax:check the manual that corresponds to your MYSQL server for the right syntax near 'PROCEDURE proc1()
BEGIN
declare sid varchar(15);

Thanks!!