Stored procedure handling Multiple Selection

[fidelity]

Hello,

 

I'm been trying to resolve for some time how to handle multiple selection criteria from JasperServer within a Oracle Stored Procedure. I know that if I call the SQL directly in the report, you can use X$ to convert a collection into a delimited string like (1,2,3). How can the same thing be achieved when dealing with Oracle Stored Procedures ? is it possible to pass the collection into oracle SP or does it need to be converted into a string? Even if it is converted into a string can the IN statement in the SP be used with the string.

 

Thanks Dipak