Re: SELECT Error: ORA-01722: Invalid Number

the use of "||" instead of "+" works. Thank you..

On Sat, 10 Mar 2001, Christoph Pfrommer wrote:

> 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 - 15:12:27 CST