SELECT Error: ORA-01722: Invalid Number

From: Chirag (Mark) Patel <patelc_at_mcss.cas.mcmaster.ca>
Date: Fri, 9 Mar 2001 20:03:33 -0500
Message-ID: <Pine.LNX.4.10.10103091959560.10544-100000@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 - 19:03:33 CST