Discussion

Passing Collections to Stored Procedure

How to pass multiple values(ResultSet/Arrays/Collection) as input paramater to stored procedure using Connect-SQL rule?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

September 10, 2013 - 6:03pm

Have you found a solution to this? I'm trying to use a Table of Objects type as the input and output for a stored procedure.  I'm pretty sure I just use {resultset} for the output but not sure how to bind the input values to the custom type.

November 17, 2014 - 6:45pm

Hi,

 

Can you please help me with the statement of executing stored procedure to retrieve result set from external table.

January 27, 2015 - 5:59am

Hi,

Even I got a requirement to pass oracle objects as IN parameter for a stored procedure.If anyone found any solution please kindly help me.

Thanks

August 31, 2015 - 10:31am

The best way to do this would be to pass "Table-Valued" parameters if possible. SQL Server supports, but not sure about Oracle. However if Pega does not support sending argument this way to SP, then obviously it not an option.

I'm using XML to do the trick. If the XML is simple enough, performance should not be an issue and beats writing clunky comma-delimited parsing.

Let me know if you are interested in SQL Server solution and I will mock up something for you.