Re: functions in packages

[Quoted] "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.
[Quoted] 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.
[Quoted] On the other hand the parser works like that since ages, so, at the end of [Quoted] 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 - 12:53:29 CET