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
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.
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