Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
Replies
4 replies
Answers
1 answer
Subscribers
6 subscribers
Views
9699 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
How to pass a null input for Execute Stored Procedure plugin expression?
Omkar K
over 7 years ago
Hello!
I am using 16.2 and SQL server. I have a stored procedure with 4 inputs and those all 4 inputs can be null. The SPROC is defined to return summation of few columns. When I am executing the stored procedure in SQL server with all inputs as null, it's returning proper data.
However, when I tried to run the SPROC with null inputs via executeStoredProcedure plugin expression, it returns just null values.
How can I get the actual results by passing null values to a stored procedure?
Thank you!
OriginalPostID-260253
Discussion posts and replies are publicly visible
Parents
0
vinayakb
over 7 years ago
Omkar, I would recommend to save the input passed to store procedure in a dummy table to know how it is interpreted when it is sent via executeStoredProcedure expression.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
vinayakb
over 7 years ago
Omkar, I would recommend to save the input passed to store procedure in a dummy table to know how it is interpreted when it is sent via executeStoredProcedure expression.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data