Question

oracle中,在一个A存储过程中打开了游标,然后把游标传给B,C存储过程使用,在B中需要再次打开游标吗?

在B中关闭了游标,C过程还能不能继续使用该游标?

Answer 1

create or replace procedure showstudent(v_cname in varchar) as
s_tmp number;
s_total number;
cursor cur_grade is select * from sc where c# in (select c# from c where cname = v_cname);
begin
for cur_rec in cur_grade loop
s_tmp := cur_rec.grade;
s_total := nvl(s_total, 0) + nvl(s_tmp, 0);
end loop;
dbms_output.put_line(v_cname || '的总分是: ' || s_total);
end;