Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I have the PLS-00323 but ..I am getting it

102805Nov 21 2001
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..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2002
Added on Nov 21 2001
5 comments
626 views