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

TIA [Quoted] I am a member of technet, but i couldn't find the error codes but i searched on too many declarations.

my fields are dates. but i changed the query and now it works.

now its to_char(hiredate - firedate), 'sssss')

But your help has been well appreciated.

Thanks

Kasper

On Tue, 9 Nov 1999 12:56:25 -0000, "Wim Valgaeren" <valgaeren_at_softhome.net> wrote:

>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:16:48 CET