Utterly simple but eluding solution: Passing a string of type IN into a procedure

I have written a explicit cursor in a procedure having a select statement of the type

Select xyz from A_TABLE
where xyz IN (string_input)

The Procedure therefore looks like as follows:- PROCEDURE SOMETHING(string_input IN VARCHAR2(30) IS
CURSOR IS
Select xyz from A_TABLE
where xyz IN (string_input);
....
END SOMETHING; Now how do I pass in correctly into the procedure a value for say string_input = 'A1','A2','A3' .
Do I need Additional quotes. I have tried passing string_input = '''A1'',''A2'',''A3'''. Though the procedure accepts the string it does not return any correct answer. How do I go about it?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 11 1999 - 17:50:10 CDT