81,092
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE pro_paper_auto_make3_1(
p_plan_id number
)
is
v_point_per number(5,1);
v_question_no_b number;
v_difficult_y number;
v_difficult_z number;
v_difficult_n number;
v_question_type varchar2(8);
v_question_id number;
j number default 0;
k number default 0;
v_kong_num number default 0;
cursor cur_plan_detail is
select
c.question_no_b,c.point_per, c.difficult_y,c.difficult_z,c.difficult_n,c.type
from t_test_plan a,t_test_paper_question_b c
where a.id = c.plan_id
and a.id = p_plan_id
order by question_no_b
;
begin
delete from t_test_paper_question_temp where paper_id=p_paper_id;
open cur_plan_detail;
loop <<planloop>>
fetch cur_plan_detail into v_question_no_b,v_point_per,v_difficult_y,v_difficult_z,v_difficult_n,v_question_type;
exit when cur_plan_detail%notfound;
j:=1;
k:=1;
begin
while j<=v_difficult_y+v_difficult_z+v_difficult_n loop <<difficult_loop>>
......
end loop difficult_loop;
end;
end loop planloop;
close cur_plan_detail;
commit;
end;