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

I get an Stored Procedure in my Oracle DB, which needs only one parameter with it's type been varchar2. 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 one of the marked rows. Is there any way to pass multiple values(marked rows from another Data Table) into stored procedure through load on-demand?

 

Any help would be greatly appreciated, thank you.

Attachments

AttachmentSize
Image icon 001.png23.69 KB
Image icon 002.png26.26 KB
Image icon 003.png6.04 KB
Image icon 004.png21.87 KB
Login