dependent cursors

[Joseph D'Emanuele]

Hello,

Is the following scenario possible? If yes, how? I am getting error: "You have an error in your SQL syntax;.." in line 8. I have MySQL 5.0.4-beta-nt

-- a stored procedure --

1: declare done int default 0;
2: decalre cur1a int;
3: declare cur1 cursor for select a from table1;
4: declare continue handler for sqlstate '02000' set done = 1;

5: open cur1;

6: repeat
7: fetch from cur1 into cur1a;
8: declare cur2 cursor for select b,c from table2 where a = cur1a;
...
9: until done end repeat;
...

Thanks for your support
Joseph