17,382
社区成员




----死循环造成的。
SQL> create or replace procedure prc as
2 cursor emp is
3 select level from dual connect by level <= 3;
4 v_id number;
5 begin
6 open emp;
7 loop
8 fetch emp
9 into v_id;
10 exit when emp%notfound;
11 dbms_output.put_line(v_id);
12 end loop;
13 end;
14 /