Skip to main content
swapnar6405
Known Participant
Dec 20, 2022 7:35 PM UTC
Question

Calling a SQL Server store procedure

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

7 replies

stefanhelzle0001
Brainy
Dec 21, 2022 9:50 AM UTC

Did you try to enter "stored" in the search field in the tools palette?

swapnar6405
Known Participant
Dec 21, 2022 3:06 PM UTC

Hi,

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.

prafuls972
Participating Frequently
Dec 21, 2022 12:48 PM UTC

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

swapnar6405
Known Participant
Dec 21, 2022 3:03 PM UTC

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.

prafuls972
Participating Frequently
Dec 21, 2022 3:07 PM UTC

you should press add plugin then search execute stored.