Re: SELECT Error: ORA-01722: Invalid Number

From: Brian Dick <bdick_at_home.com>
Date: Sat, 10 Mar 2001 02:46:51 GMT
Message-ID: <vAgq6.13716$PR.92419@news1.wwck1.ri.home.com>

What's the data type of "requestor"? It had better be a char or varchar. The LIKE operator is for strings.

"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 - 20:46:51 CST