游浪踏

导航

 
create or replace 
function fun_cust_change_manager(in_cust_id varchar2,in_change_manager in varchar2,change_reason in varchar2,in_group_id in varchar2,in_dept_id in varchar2,in_op_login varchar2)
return varchar2
as
PRAGMA AUTONOMOUS_TRANSACTION;
returnCode varchar2(10);
update ct_cust_info a set a.sale_manager = in_change_manager, a.group_id = in_group_id,a.dept_id = in_dept_id where a.cust_id = in_cust_id;
update ct_custmanager_rel a set a.staff_login=in_change_manager,a.login_no =in_change_manager where a.cust_id = in_cust_id;
commit;
return returnCode;
end fun_cust_change_manager;

通过 select fun_cust_change_manager(参数) from dual;就可以调用

posted on 2017-05-11 09:58  游浪踏  阅读(1805)  评论(0编辑  收藏  举报