oracle code createorreplaceprocedure proc_permission_deletebyid(spitemid1 invarchar2) is docid1 varchar2(50); charge1 varchar2(50); begin deletefrom t_sys_permissionitem where id=spitemid1; deletefrom t_sys_busiitem where spitemid=spitemid1;
declarecursor spitemdoc_cur is----定义文档游标 select docid from t_con_spitemofdoc where spitemid=spitemid1; begin open spitemdoc_cur; fetch spitemdoc_cur into docid1; while spitemdoc_cur%found loop deletefrom t_sys_document where id=docid1; fetch spitemdoc_cur into docid1; end loop; close spitemdoc_cur; end;
deletefrom t_con_spitemofdoc where spitemid=spitemid1;
declarecursor spitemcharge_cur is---定义收费游标 select chargeid from t_con_spitemofcharge where spitemid=spitemid1; begin open spitemcharge_cur; fetch spitemcharge_cur into charge1; while spitemcharge_cur%found loop deletefrom t_sys_charge where id=charge1; fetch spitemcharge_cur into charge1; end loop; close spitemcharge_cur; end;
deletefrom t_con_spitemofcharge where spitemid=spitemid1; deletefrom t_con_spitemofopinion where spitemid=spitemid1; deletefrom t_con_spitemoftbcx where spitemid=spitemid1; deletefrom t_con_spitemofposition where spitemid=spitemid1; end proc_permission_deletebyid;
调用如下:
begin proc_permission_deletebyid( '410700417088036001'); end;
posted on
2009-10-23 09:22小顾问
阅读(402)
评论(0)
编辑收藏举报