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

[Quoted] 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 - 12:11:33 CET