Re: SELECT Error: ORA-01722: Invalid Number

Try to replace "+" with "||".

"Chirag (Mark) Patel" <patelc_at_mcss.cas.mcmaster.ca> wrote in message news:Pine.LNX.4.10.10103091959560.10544-100000_at_mcss.cas.mcmaster.ca...
> 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 Fri Mar 09 2001 - 23:25:52 CST