1、代码片段
声明
function f_get_res_new_1(i_item_id in t_contract_product.item_id%type,
i_acc_date in date,
i_claimed in number,
i_policy_id in number
) return number;
方法体
function f_get_res_new_1(main_item_id in t_contract_product.item_id%type,
i_acc_date in date,
i_claimed in number, -- 0 not claimed 1 claimed
i_policy_id in number
) return number as
编译时报错如下
Error: PLS-00323: subprogram or cursor 'F_GET_RES_NEW_1' is declared in a package specification and must be defined in the package body
2、原因分析
相信大家已经看出来了,声明部分和方法体部分的参数名称不一致