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!

Reg: Package Spec and Body

EV259Jul 25 2013 — edited Jul 25 2013

All,

I am adding a function to an existing package. I have added the function code only in the package body and compiled. I have received the below error.

PLS-00313: 'Fun_check' not declared in this scope

Where as, I have declared the same function in the package specification, then no issues.

So, my question is, Can't we add the function/procedure without the declaration of it inside the package specification.Because,I see,  there were many functions inside the same package body, which were not declared in the package specification.  What will happen,  if we declare the function/proc  inside the package spec and what if not.

Thanks in advance.

Thanks,

This post has been answered by Ashu_Neo on Jul 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2013
Added on Jul 25 2013
6 comments
3,426 views