Question

4
Replies
149
Views
DeepaRaniR Member since 2013 1 post
Cognizant Solutions
Posted: June 22, 2018
Last activity: June 23, 2018
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***

Data Integration SR Exists
Moderation Team has archived post
Share this page LinkedIn