PLS-00323

Hello,

I have created a package and procedure that include a function which defined in package body. This function has three parameter in package. When I change number of parameter of function in package body, I've got PLS-00323 error.

Instance of package;

CREATE OR REPLACE package SYSPROD.test_procedure is
    function test_inv (p_emplid in number,p_seqno in number,p_date in varchar2) return varchar2;
    end test_procedure;
/

Instance of package body;

CREATE OR REPLACE package body SYSPROD.test_procedure is
    function test_inv (p_emplid in number,p_seqno in number,p_date in varchar2,p_invoice_address  varchar2) return varchar2 is
       PRAGMA AUTONOMOUS_TRANSACTION;
    cursor c_cursor is
                     /*sql statement as you need....
                       ........................
                       ........................*/
                   
/* Declarations ......*/
 
    begin
       .....
    end;

end test_procedure;


You can see my fault. Both of functions' parameters doesn't match.

In that case, this error meaning is function's parameter number in package is not match function's parameter number in package body. So I modified parameter number of function in package than problem resolved.

Loves,