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

 Deepa Rani Relamadugu (DeepaRaniR)
Cognizant Solutions

Cognizant Solutions
US
DeepaRaniR Member since 2013 1 post
Cognizant Solutions
Posted: Jun 22, 2018
Last activity: Jun 23, 2018
Posted: 22 Jun 2018 16:02 EDT
Last activity: 23 Jun 2018 19:53 EDT
Closed

Unable to pass Array as input to store procedure

Hi,

We are calling Connect SQL (RDB-Save) to external database, where we are calling a stored procedure which accepts input parameters in Array format.

when we tried with using valuelist property and referring the same in connect sql in following format Ex:{InputPage.ValueList} or {InputPage.ValueList()},it was throwing error.

Tried with different option by constructing the values in array format and assigned to string property. referring that property in connect sql also throwing error.

Tried with Java method using Preparecall statement with passing Java object(for array), also did not help with resolution.

we have created SR-C40756, please help us if there is any solution.

Thanks

Deepa

***Edited by Moderator Marissa to update SR Details***

To see attachments, please log in.
Data Integration
Support Case Exists

  • Ashari Gamage
Posted: 6 years ago
Posted: 23 Jun 2018 19:53 EDT
Deepa Rani Relamadugu (DeepaRaniR)
Cognizant Solutions

Cognizant Solutions
US

Hi Arun,

The link which you provided is about how to process output of resultset from stored procedure. But my requirement is to pass array input to stored procedure. Which I could not find the link you shared.

 

Thanks

Deepa

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