Hi,
I have to make a call to SQL Server stored procedure with input parameters and get the return value.
I have gone through the below URL for required documentation.
docs.appian.com/.../Execute_Stored_Procedure_Smart_Service.html
I am using 21.4 version of Appian, but still, I don't see Execute Stored Procedure smart service in my list of smart services.
Can someone advise on this please.
Thank you
Discussion posts and replies are publicly visible
Did you try to enter "stored" in the search field in the tools palette?
To use execute stored procedure you need to install execute stored procedure plugin on your environment. After successful installation you will start to see it as a function and smart service
Thanks for your response.
When I looked into "Plug-ins" under admin console, I have not found plug-in for " Execute Stored Procedure". Any further advises please. Thank you.
I have already tried this option. Please find the attached screen shot.
Do you think my version 21.4.770.0 is not having this smart service.
you should press add plugin then search execute stored.
Interesting. I don't have any such option to add any kind of plug-ins even though I have logged in as system admin.
I assume you're on a self-managed environment? If so there are different instructions for adding plug-ins, see here: docs.appian.com/.../Appian_Plug-ins.html