3,491
社区成员
发帖
与我相关
我的任务
分享
--代码一:
v_title := bep_process_public.f_get_bill_oa_title(p_business_no => expr1,
p_business_no_type => expr2);
UPDATE lend_apply_info lai
SET lai.title = v_title
WHERE lai.lend_apply_no = v_lend_apply_no;
IF SQL%ROWCOUNT = 0 THEN
p_flag := '1';
p_msg := '更新Title失败!';
RAISE e_proc_exception;
END IF;
--代码二:
UPDATE lend_apply_info lai
SET lai.title = bep_process_public.f_get_bill_oa_title(p_business_no => expr1,
p_business_no_type => expr2)
WHERE lai.lend_apply_no = v_lend_apply_no;
IF SQL%ROWCOUNT = 0 THEN
p_flag := '1';
p_msg := '更新Title失败!';
RAISE e_proc_exception;
END IF;