oracle如何用游标取值,oracle – 如何从游标中获取值到变量？

我在从游标中获取值到变量时遇到问题：

create or replace

procedure projectinfo(num clubs.clubid%type)

as

--identify variables

p_cln clubs.clubname%type;

p_projn projects.projectname%type;

p_projnum number;

p_taskn tasks.taskname%type;

p_tasknum number;

cursor cur is

select c.clubname, p.projectname, t.taskname

from clubs c join projects p on c.clubid=p.clubid

join tasks t on t.projectid=p.projectid

where c.clubid=num;

--I have checked the above cursor and it's worked fine!!!

begin

p_projnum:=0;

p_tasknum:=0;

open cur;

loop

fetch cur into p_cln,p_projn, p_taskn;

dbms_output.put_line(p_cln|| ' ' ||p_projn|| ' ' || p_taskn);

-- the above command does not print variable values!!!

exit when cur%notfound;

p_projnum:=p_projnum+1;

dbms_output.put_line(' ************************ ');

dbms_output.put_line(' club name : ' ||p_cln);

dbms_output.put_line( ' project ' ||p_projnum|| ' ' || p_projn);

loop

p_tasknum:=p_tasknum+1;

dbms_output.put_line('Task: ' ||p_tasknum|| ' ' || p_taskn);

fetch cur into p_cln,p_projn, p_taskn;

exit when cur%notfound;

end loop;

end loop;

close cur;

end projectinfo;

我检查了我的光标,它包含了我需要的所有值.我的程序编译FINE但不打印任何输出！