loop
fetch c_advice into v_ID,v_ZT;
dbms_output.put_line(v_ID||' '||v_ZT);
exit when c_advice%notfound;
end loop;
end;
fetch c_advice into v_ID,v_ZT;
dbms_output.put_line(v_ID||' '||v_ZT);
exit when c_advice%notfound;
end loop;
end;
应该是:
fetch c_advice into v_ID,v_ZT;
exit when c_advice%notfound;
dbms_output.put_line(v_ID||' '||v_ZT);