Skip to main content
swapnar6405
swapnar6405
December 20, 2022
Question

Calling a SQL Server store procedure

  • December 20, 2022
  • 7 replies
  • 0 views

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
stefanhelzle0001
Brainy
December 21, 2022

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

swapnar6405
swapnar6405Author
December 21, 2022

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
prafuls972
December 21, 2022

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
swapnar6405Author
December 21, 2022

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
prafuls972
December 21, 2022

you should press add plugin then search execute stored.

Terms & ConditionsAccessibility statement