Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
10 replies
Subscribers
9 subscribers
Views
10114 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Passing single input variable with multiple values to Stored Proc
jaishankarj
over 8 years ago
Hi All. I am trying to execute a stored proc from SAIL having a input parameter as pinABC which is of type Text and can hold multiple values. The stored proc will execute a query having where clause as "WHERE ABC IN (pinABC)". When a single value is getting passed to the stored proc it is working fine, but the moment there are multiple values being passed from SAIL - it is failing. Any help on how to pass a parameter with multiple values to Stored Proc? Sample query as below:
local!spResult:fn!executestoredprocedure(
dataSourceName: <Data Source Name>,
procedureName: <Stored Proc Name>,
inputs: {{name: "pinABC",value:tostring(ri!ABC)}
}
)
Note: The rule input is of type Text and can have multiple values
OriginalPostID-236582
Discussion posts and replies are publicly visible
Parents
0
vinayakb
over 8 years ago
From what I understand, the issue could be in Store procedure "where in" clause. In any case if you try to split the values comma separated in Appian, it will still consider as 1 string in stored procedure. It is best you split the string in SP. May be you can check the below link
stackoverflow.com/.../how-to-separate-split-string-with-comma-in-sql-server-stored-procedure
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
vinayakb
over 8 years ago
From what I understand, the issue could be in Store procedure "where in" clause. In any case if you try to split the values comma separated in Appian, it will still consider as 1 string in stored procedure. It is best you split the string in SP. May be you can check the below link
stackoverflow.com/.../how-to-separate-split-string-with-comma-in-sql-server-stored-procedure
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data