Re: too many declarations of '-'match this call?

[Quoted] I once got the too many declarations error when I tried to do a to_char on a char. Maybe you can check that hiredate and firedate are dates and not chars.
For information on error codes you can go to http://technet.oracle.com There you can find any error code with description, cause and action. Just search on the error code ie: pls-00307

Regards,
Wim Valgaeren

<qenr_at_vara.nl> wrote in message news:38280098.11597989_at_news.omroep.nl...
> Thanks for the help below.
>
> The error message i get is when i try to subtract two datetimes from
> each other.
>
> i.e. select to_char(hiredate, 'sssss') - to_char(firedate, 'sssss')
> which works fine in sql but in forms i get this mismatch call.
> hope this helps because the plsql editor does not give any error types
> or codes except 307 and 386 but I cannot find these error messages in
> any manual.
>
> TIA for any help.
>
>
>
> On Tue, 9 Nov 1999 11:54:48 -0000, "Wim Valgaeren"
> <valgaeren_at_softhome.net> wrote:
>
> >Maybe you can give the code where you get the error message?
> >
> >PLS-00307 too many declarations of name match this call
> >
> >Cause: The declaration of a subprogram name is ambiguous because there
was
> >no exact match between the declaration and the call and more than one
> >declaration matched the call when implicit conversions of the parameter
> >datatypes were used. The subprogram name might be misspelled, its
> >declaration might be faulty, or the declaration might be placed
incorrectly
> >in the block structure.
> >
> >Action: Check the spelling and declaration of the subprogram name. Also
> >confirm that its call is correct, its parameters are of the right
datatype,
> >and, if it is not a built-in function, that its declaration is placed
> >correctly in the block structure.
> >
> >Regards,
> >Wim Valgaeren
> >
> ><qenr_at_vara.nl> wrote in message news:3827ddd4.2696281_at_news.omroep.nl...
> >> Does anyone know what this forms error means?
> >> Why does my query in sql work fine but do i get this error message in
> >> my forms plsql trigger.
> >>
> >> TIA
> >
> >
>
Received on Tue Nov 09 1999 - 13:56:25 CET