oracle 《is declared in a package specification and must be defined in the package body报错原因》

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、原因分析

相信大家已经看出来了，声明部分和方法体部分的参数名称不一致