17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE
PROCEDURE p_bctts_enterext_update
(var_id in number,
var_old_address varchar2,
var_new_address varchar2,
var_coperation varchar2,
var_bj_manager varchar2,
var_phone varchar2,
var_email varchar2,
var_consigner varchar2,
var_deputy varchar2,
var_accredit_content varchar2,
var_deputy_start_date date,
var_deputy_end_date date)
IS
var_errormsg varchar2(4000);
var_zyxt_enterprise_id varchar2(16);
BEGIN
var_errormsg := '';
var_zyxt_enterprise_id := '';
select zyxt_enterprise_id
into var_zyxt_enterprise_id
from t_enterprise_info
where id = var_id;
update bctts.t_enterprise_info
set bctts.t_enterprise_info.old_address = var_old_address,
bctts.t_enterprise_info.new_address = var_new_address,
bctts.t_enterprise_info.coperation = var_coperation,
bctts.t_enterprise_info.bj_manager = var_bj_manager,
bctts.t_enterprise_info.phone = var_phone,
bctts.t_enterprise_info.email = var_email,
bctts.t_enterprise_info.consigner = var_consigner,
bctts.t_enterprise_info.deputy = var_deputy,
bctts.t_enterprise_info.accredit_content = var_accredit_content,
bctts.t_enterprise_info.deputy_start_date = var_deputy_start_date,
bctts.t_enterprise_info.deputy_end_date = var_deputy_end_date
where enterprise_id = var_zyxt_enterprise_id;
COMMIT;
EXCEPTION
when others then
var_errormsg := SUBSTR(SQLERRM, 1, 4000);
INSERT INTO t_zyjcxxsync_error_info
(f_tablename,
t_tablename,
op_type,
primary_value,
errormsg,
operate_date,
remark)
VALUES
('bcpbs.t_enterpriseextend_info',
'bctts.t_enterprise_info',
'update',
var_id,
var_errormsg,
sysdate(),
'p_bctts_enterext_update');
ROLLBACK;
RETURN;
end;