Is there any way to call a Stored procedure(having some input parameters) that updates/Writes to DB

Question

Hi, 
 I have created a stored procedure which takes some input parameters and based on parameters, Insert query gets executed. I want to Call this Procedure either through SAIL Interface or Process Model. I cannot use fn!executestoredprocedure function as i am writing to db. 
 Can someone suggest on the same 
 Regards 
 Venkatesh

arikd398 · Accepted Answer

Hi venkatesha0002 ,

To pass the parameter in Execute Stored Procedure smart service.You need to create the pv with the same name that is in the input parameters of the calling procedure.

And in the data --> input tab of the Execute Stored Procedure node you have to map those pv! with the values which you want to pass.

Suppose for example you have a procedure:

xyz
(input1,
input2
);

Then you have to create pv!input1,pv!input2 and in the input tab you have to map the values you want to pass in these input parameters and then send this pv!'s in the calling stored procedure.

Abhay Giri · Answer

Hi Venkatesh, 
 
You need to create input parameter with the same name & type as in your sproc have. 
 
Example your sproc have two parameter , Name varchar & Age Int. Then in execute store procedure smart service create two node with same name , Name & Age and assign value by using process variable. 
Then you sproc will get execute. 
 
Let me know weather it helps you or not. 
 
Regards 
Abhay

Shiva Valusa · Answer

Hi, 
 You can use Execute Stored Procedure smart service in process model.

Shubham Aware · Answer

Hi Venkatesh, 
 To execute stored procedure appian provide smart service called "Execute stored procedure" try this.... 
 T hanks, 
 Shubham