SQL help

I am creating a package for Oracle 8i. I need to pass a variable in and use that in the SQL statement IN clause. This worked for a simple equal statement but not for the IN.

'select * from CUSTOMERS where CUSTOMERS_CODE in (:x1) ' USING IDS;

where IDS is VARCHAR2 and = 999,1000

Thanks in advance Received on Thu May 12 2005 - 19:46:05 CDT