--比较判断条件，看是否将数据插入到result数据库中
if(graduaterecord.yingyu>=tempyingyu and
graduaterecord.zhengzhi>=tempzhengzhi and
graduaterecord.zhuanye1>=tempzhuanye1 and
graduaterecord.zhuanye2>=tempzhuanye2 and
graduaterecord.zhuanye3>=tempzhuanye3 and
graduaterecord.totalscore>=temptotalscore )
then
graduateflag:='录取'
else
graduateflag:='落选'
--退出if
end if;
--退出游标循环
exit when graduatecursor%notfound;
insert into result(BH,xm,lb,yingyu,zhengzhi,zhuanye1,zhuanye2,zhuanye3,totalscore,flag)
values(graduaterecord.BH,graduaterecord.XM,graduaterecord.LB,graduaterecord.YINGYU,graduaterecord.ZHENGZHI,
graduaterecord.ZHUANYE1,graduaterecord.ZHUANYE2,graduaterecord.ZHUANYE3,graduatetotalscore,graduateflag);
end loop;
--关闭游标
close graduatecursor;
commit;--提交结果
--处理异常
exception
when errormessage then
dbms_output.put_line('无法打开数据表');
/*程序执行结束"*/
end;
end graduateprocess;--存储过程结束