CRN - Using a multi-select prompt with Stored Procedure?

[stacybost]

Has anyone used a multi-select prompt with a stored procedure data source in Cognos ReportNet?

I want to offer a required multi-select prompt, so that the user can select one or more values. Then, in the SP, the SQL would contain a 'WHERE COLUMNNAME in (input_parameter)' clause. Just not sure how the values will be passed in the parameter, or how Oracle will like it, so thought I'd see if anyone else had done this first.

Thanks,
Stacy