I have the PLS-00323 but ..I am getting it
Ok here is the declaration in the the package header..
FUNCTION fn_populate_rgns_from_national(fv_sales_force_no IN
tsales_force.sales_force_no%TYPE
,fv_budget_no IN tbudget_plan.budget_no%TYPE) RETURN VARCHAR2;
....now here is the package body ...
Function fn_populate_rgns_from_national(fv_sales_force_no IN
tslaes_force.sales_force%TYPE ,
fv_budget_no IN tbudget_plan.budget_no%type) RETURN VARCHAR2 IS
BEgin
< yada > <yada>
ENd ;
As far as I can tell...the declaration is the same in the
package header and body...then why the heck, I am getting the
PLS-0323 error :
LINE/COL ERROR
-------- --------------------------------------------------------
---------
5/10 PLS-00323: subprogram or
cursor 'FN_POPULATE_RGNS_FROM_NATIONAL'
is declared in a package specification and must be
defined in the
package body
I am at my wits end..