How do I pass multiple values into Information Link(with Oracle Stored Procedure)

[Albert Chang 2]

Iget an Stored Procedure in my Oracle DB, which needs only one parameterwith it'stypebeenvarchar2. And I create a Procedure Elements in Information Designer loos like 001.png. Then I create an Information Link with no any parameter(see 002.png). And in my Library, I add a new Data Table by chossing the IL I just created, and press "Use On-demand"(see 003.png). Then, I Define the Input of On-Demand Settings as 004.png.

 

BUT! When I mark some rows of Data Table: CPBINMAPSIMILARITY, the other Data Table(let's say ILTable) shows only one item which's GROUP_NAME is oneof the marked rows. Is there any way to pass multiple values(marked rows from another Data Table) into stored procedurethrough load on-demand

 

Any helpwould begreatly appreciated, thank you.