Re: SELECT Error: ORA-01722: Invalid Number

From: Christoph Pfrommer <Christoph.Pfrommer_at_oracle.com>
Date: Sat, 10 Mar 2001 09:34:15 +0100
Message-ID: <3AA9E707.B68A699@oracle.com>

Oracle's syntax for concatenation of strings is: '%' || :input_requestor || '%'
(but not a plus sign)
My guess is that the parser rather expects numbers not strings when the WHERE clause has a + in it.

"Chirag (Mark) Patel" wrote:

> Can someone give me details about the following error I got at runtime:
>
> SELECT Error: ORA-01722: Invalid Number
>
> Thanks.
>
> ========
> I was entering the following SQL QUERY in the datawindow painter in
> Powerbuilder:
>
> SELECT .....
> FROM .....
> WHERE (requestor LIKE '%' + :input_requestor + '%');
Received on Sat Mar 10 2001 - 02:34:15 CST