hey guys - 

Any reason why this won't work?

DECLARE

	   t_list VARCHAR(100) := '1,2,3,4';

	   CURSOR c IS
	   SELECT * FROM 
	   TBL_REQ_DATA
	   WHERE
	   IDData IN (t_list);
	   
	   
BEGIN
	 OPEN c;
	 CLOSE c;
END;
	 

I'm doing something similar on another stored proc, where I create a list of ids, and 
then want to select data using an 'in' statement.

I take it this is disallowed from a stored procedure, and I'm guessing i'm going to 
have to go back to my coldfusion to grab the data I want?

TIA, I'm stuck.

Mark
-----------------------------------
mark@safefrombees.com       
ICQ: 3094740
Safe From Bees
[www.safefrombees.com]
