Jump to content
We've recently updated our Privacy Statement, available here. ×

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


Albert Chang 2

Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...