第一次自己写存储过程去进行设备录入――存做纪念

大佬教程收集整理的这篇文章主要介绍了第一次自己写存储过程去进行设备录入――存做纪念，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

-----录设备-存储过程
createorreplaceprocedurelu_shebei(r_resoutvarchar2)is
typet_cursorisrefcursor;
v_mycurt_cursor;
v_yonghu_IDyong_hu.id%type;
v_IDyonghu_luyou_xiangqing.ID%type;
v_luyou_IDyonghu_luyou.id%type;
v_shebei_iDpeixian_jia.ID%type;
v_shebei_bianmapeixian_jia.bian_hao%type;
v_mokuai_iDpeixian_mokuai.ID%type;
v_mokuai_bianmapeixian_mokuai.bian_hao%type;
v_jusuo_IDyong_hu.ju_suo%type;
v_xu_haoyonghu_luyou_xiangqing.xu_hao%type;
v_duankou_leibIEpeixian_duanzi.shebei_Dalei%type;
v_lIEvarchar2(255);
v_kuaivarchar2(255);
v_duankou_IDpeixian_duanzi.ID%type;
v_duankou_haopeixian_duanzi.duanzi_hao%type;
v_sqlvarchar2(255);
v_countnumber(10);
v_lu_shebei_ilu_shebei_i%rowtype;
begin
v_sql:='SELEct*fromlu_shebei_i';
openv_mycurforv_sql;
fetchv_mycurintov_lu_shebei_i;
whilev_mycur%foundloop
SELEctcount(*)intov_countfromyong_huywherey.fuwu_haoma=''||v_lu_shebei_i.fuwu_haoma||'';
ifv_count!=0then
SELEcty.IDintov_yonghu_IDfromyong_huywherey.fuwu_haoma=''||v_lu_shebei_i.fuwu_haoma||'';
SELEcty.ju_suointov_jusuo_IDfromyong_huywherey.fuwu_haoma=''||v_lu_shebei_i.fuwu_haoma||'';
SELEctl.IDintov_luyou_IDfromyonghu_luyoulwherel.yonghu_ID=''||v_yonghu_ID||'';
SELEct'0'||TO_CHAR(count(xu_hao)+1)||'.1'intov_xu_haofromyonghu_luyou_xiangqingxwherex.luyou_ID=''||v_luyou_ID||'';
SELEctp.IDintov_shebei_iDfrompeixian_jiapwherep.bian_hao=''||v_lu_shebei_i.SHEBEI_BIANMA||'';
SELEctp.bian_haointov_shebei_bianmafrompeixian_jiapwherep.bian_hao=''||v_lu_shebei_i.SHEBEI_BIANMA||'';
SELEctm.IDintov_mokuai_iDfrompeixian_mokuaimwherem.peixian_jia_ID=''||v_shebei_iD||''andm.lIE=''||v_lu_shebei_i.LIE||''andm.kuai=''||v_lu_shebei_i.KUAI||''andm.shebei_Dalei=5;
SELEctm.bian_haointov_mokuai_bianmafrompeixian_mokuaimwherem.peixian_jia_ID=''||v_shebei_iD||''andm.lIE=''||v_lu_shebei_i.LIE||''andm.kuai=''||v_lu_shebei_i.KUAI||''andm.shebei_Dalei=5;
SELEctz.shebei_Daleiintov_duankou_leibIEfrompeixian_duanzizwherez.mokuai_iD=''||v_mokuai_iD||''andz.duanzi_hao=''||v_lu_shebei_i.DUANZI||'';
SELEctz.IDintov_duankou_IDfrompeixian_duanzizwherez.mokuai_iD=''||v_mokuai_iD||''andz.duanzi_hao=''||v_lu_shebei_i.DUANZI||'';

inserTintoyonghu_luyou_xiangqing
values(
seq_diaodu_luyou_xiangqing.nextval,v_luyou_ID,v_xu_hao,'201','',v_jusuo_ID,'0',v_shebei_iD,v_shebei_bianma,'5',v_mokuai_iD,v_mokuai_bianma,v_lu_shebei_i.LIE,v_lu_shebei_i.KUAI,v_duankou_leibIE,v_duankou_ID,v_lu_shebei_i.DUANZI,''||v_shebei_iD||'.'||v_duankou_leibIE||'-3121566.44;-1;0;1','1','zmr',sysdate,'6471011',sysdate
);
commit;
else
inserTintoinsert_log
values(
v_lu_shebei_i.fuwu_haoma,v_lu_shebei_i.shebei_bianma,v_lu_shebei_i.lIE,v_lu_shebei_i.kuai,v_lu_shebei_i.duanzi);
commit;
r_res:=v_lu_shebei_i.fuwu_haoma||'用户不存在';
endif;

deletefromlu_shebei_iwherefuwu_haoma=''||v_lu_shebei_i.fuwu_haoma||'';
fetchv_mycurintov_lu_shebei_i;
endloop;
closev_mycur;
commit;

endlu_shebei;

----未录入设备的log日志
SELEct*frominsert_log;

--录设备中间表
SELEct*fromlu_shebei_iforupdate;

---执行存储
declare
v_resvarchar2(254);
begin
lu_shebei(v_res);
end;

大佬总结

以上是大佬教程为你收集整理的第一次自己写存储过程去进行设备录入――存做纪念全部内容，希望文章能够帮你解决第一次自己写存储过程去进行设备录入――存做纪念所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。