- 论坛徽章:
- 1
|
本帖最后由 visician 于 2013-04-09 20:20 编辑
No data - zero rows fetched, selected, or processed
我知道是游标的问题,但是,我单独运行存储过程不会报错,
下面是存储过程- BEGIN
- DECLARE done int default 0;
- DECLARE EntityID varchar(11);
- declare Entity_name varchar(20);
- declare onlinenum int;
- declare Totalnum int;
- DECLARE authors_cursor CURSOR FOR SELECT id, Name FROM Entity;
- declare CONTINUE HANDLER for not found set done=1;
- open authors_cursor;
- operate_loop:LOOP
- FETCH authors_cursor INTO EntityID, Entity_name;
- if done=1 THEN
- leave operate_loop;
- end if;
-
-
-
- END loop operate_loop;
- CLOSE authors_cursor;
- END
复制代码 |
|