Re: too many declarations of '-'match this call?
From: Jason Judge <jason.judge_at_virgin.net>
Date: Wed, 10 Nov 1999 23:55:11 -0000
Message-ID: <80cvvd$a8j$1_at_nclient15-gui.server.virgin.net>
Date: Wed, 10 Nov 1999 23:55:11 -0000
Message-ID: <80cvvd$a8j$1_at_nclient15-gui.server.virgin.net>
The reason for the error is exactly what it says - Oracle does not know how to handle the '-' you have supplied in the equation. Subtracting a string from a string does not make sense (i.e. you cannot do it) so the two strings you have supplied need to be converted into something else. You have allowed some ambiguity here - should they be converted into dates? Into a date and a number? A number and a date? This ambiguity is where the error is being raised.
Regards,
Jason Judge Received on Thu Nov 11 1999 - 00:55:11 CET