Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Arun kumar (Arun kumar)
HCL Technologies

HCL Technologies
IN
Arun kumar Member since 2013 13 posts
HCL Technologies
Posted: Nov 3, 2017
Last activity: Nov 21, 2017
Posted: 3 Nov 2017 7:40 EDT
Last activity: 21 Nov 2017 7:32 EST
Closed

How to pass array as parameter to Store procedure

I need to pass array as parameter to Store procedure. I tried with Value list & Page list and referred in Connect SQL but it doesn't work. Kindly find my code below in Connect-SQL and someone pls tell me how to pass array from Pega.

DECLARE

BEGIN

SchemaName.StoreProcName({TestPage.ValueListPropName IN})

END

---***----

Do i need to refer Value list or Page list to pass as parameter? and how to refer in the rule.

Little urgent to deliver this code so any help is highly appreciated.

To see attachments, please log in.
Low-Code App Development
Java and Activities

Posted: 7 years ago
Posted: 3 Nov 2017 11:06 EDT
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Arun,

You can go through the below discussions where they discussed about passing list data to stored procedure as well which might help you,

https://pdn.pega.com/community/product-support/question/calling-stored-procedure-using-connect-sql

https://collaborate.pega.com/discussion/it-possible-call-stored-procedures-pega

Regards

Mahesh

To see attachments, please log in.
Posted: 7 years ago
Posted: 21 Nov 2017 7:32 EST
Arun kumar (Arun kumar)
HCL Technologies

HCL Technologies
IN
Thanks Mahesh for your response. I achieved this to pass parameter with single value but struggling via array or xml.. Both the above links not clearly mentioned to pass as array.
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice