写了个简单的ORACLE存储过程,但是游标报错,大神看看怎么回事?

2025-04-29 01:33:49
推荐回答(1个)
回答1:

create or replace procedure sp_series
as
v_id varchar2(15);
v_n varchar2(2);
v_m varchar2(2);
cursor party is select party_id from p_time_6;
cursor all_rep is select party_id,n,m from p_time_5 where party_id=p;
p party%type;
x all_rep&type;
begin
for p in party loop
for x in all_rep loop
v_id := x.party_id;
v_n := x.n;
v_m := x.m;
for nm in 1..v_m loop
insert into p_time_7 select party_id,n from p_time_5 where v_n=1;
exit when v_m = 2;
end loop;
commit;
end loop;
end loop;
end sp_series;