两个或多个游标怎么做?

[liangCK]

declare cur1 cursor for (select id from t group by id);
declare continue handler for sqlstate '02000' set done1=1;
declare cur2 cursor for (select tm from t where id=t_id);
declare continue handler for sqlstate '02000' set done2=1;

这样错了.
如果当使用多个游标时怎么办?.

[budong0000]

go

[懒得去死]

你要怎么办？

和循环的嵌套是一个原理。

[liangCK]

我是想这样的.
假如这个成立的话.
declare cur1 cursor for (select id from t group by id);
declare continue handler for sqlstate '02000' set done1=1;
declare cur2 cursor for (select tm from t where id=t_id);
declare continue handler for sqlstate '02000' set done2=1;

那我就可以
while done1=0 do
while done2=0 do

end while;
end while;

这样进行循环.
但是如果只有一个declare continue handler..我就想不到怎么用一个done去判断两个游标的读取错误.