Xref: alice comp.databases.oracle.tools:35358
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!colt.net!news-lond.gip.net!news.gsl.net!gip.net!news5-gui.server.ntli.net!news11-gui.server.ntli.net!ntli.net!not-for-mail
From: "Jason Judge" <jason.judge@virgin.net>
Newsgroups: comp.databases.oracle.tools
Subject: Re: too many declarations of '-'match this call?
Date: Wed, 10 Nov 1999 23:55:11 -0000
Organization: Virgin Net Usenet Service
Lines: 14
Message-ID: <80cvvd$a8j$1@nclient15-gui.server.virgin.net>
References: <3827ddd4.2696281@news.omroep.nl> <808u4h$9cc$1@naxos.belnet.be> <38280098.11597989@news.omroep.nl> <8091o5$cbg$1@naxos.belnet.be> <38280fc4.15482526@news.omroep.nl>
X-Trace: nclient15-gui.server.virgin.net 942277421 10515 62.252.133.72 (10 Nov 1999 23:43:41 GMT)
X-Complaints-To: abuse@virgin.net
NNTP-Posting-Date: 10 Nov 1999 23:43:41 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200

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