Re: functions in packages

May be, but that doesn't mean that the error message is misleading, does it? At any rate, after some time you get used to it and you know where to look at, but for someone new to PL/SQL is not particularly helpful that message IMHO. Bye,
Flavio

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:2MN2a.7320$jR3.3767994_at_news1.news.adelphia.net...
> Isn't the problem here that because overloading is allowed the compiler is
> looking not for the original last_cap (without params), but an entirely
> different last_cap with one param??????
>
>
>
>
> "FC" <flavio_at_tin.it> wrote in message
> news:ZGL2a.233964$AA2.9062774_at_news2.tin.it...
> >
> > "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> > news:3E4B283F.2AE2DDEE_at_exesolutions.com...
> > > Dwayne wrote:
> > >
> > >> ....
> > > > Warning: Package Body created with compilation errors.
> > > >
> > > > SQL> show error
> > > > Errors for PACKAGE BODY CAP:
> > > >
> > > > LINE/COL ERROR
> > >
> >
>
> -------- -----------------------------------------------------------------
> > > > 3/10 PLS-00323: subprogram or cursor 'LAST_CAP' is declared in a
> > > > package specification and must be defined in the package
body
> > > >
> > > > I spent 3 hours on this trying different combos but nothing.
> > >
> > > There is no relationship between what you have written in the package
> > header
> > > and the function in the package body. The package header does not
> > reference
> > > your input parameter NAME VARCHAR2.
> > >
> > > Daniel Morgan
> > >
> >
> > For the sake of intellectual honesty, I've always found that error
message
> > very misleading.
> > If the problem lies in a wrong argument count, I wonder why the error
> > message isn't saying "Wrong argument count" or "Bad function
> specification"
> > or alike.
> > On the other hand the parser works like that since ages, so, at the end
of
> > the day, there is very little room for complaints, just take it as it is
> and
> > run...
> >
> > Bye,
> > Flavio
> >
> >
>
>
Received on Thu Feb 13 2003 - 15:32:08 CET