exception
when others then
v_errorcode := sqlcode;
v_errormsg := sqlerrm;
rollback;
insert into t_wa_sys_log_err
(err_date, name_proc, err_code, err_msg)
values
(sysdate, ‘p_sy_hcp_ywcx’, v_errorcode, v_errormsg);
v_ret := 99;
commit;
end;
08-01