oracle中游标出现问题，求解释

2025-03-23 19:01:11

推荐回答（2个）

回答1：

fetch关键字错了吧，你写成了fecth，
别外，c consume_cursor%rowtype;这点有问题，应该是c consume%rowtype;
还有if consume_crusor%found then这点也写错了应该是if consume_cursor%found then

回答2：

declare
cursor consume_cursor is
select * from consume where cno = '219990004800017';
c consume_cursor%rowtype;
begin
open consume_cursor;
loop
fetch consume_cursor into c;
exit when consume_cursor%notfound;
dbms_output.put_line('第' || consume_cursor%rowcount || '行消费信息：' || c.no);
end loop;
close consume_cursor;
end;