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
Discussion posts and replies are publicly visible
You can use Execute Stored Procedure smart service in process model.
To execute stored procedure appian provide smart service called "Execute stored procedure"try this....
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.
© 2023 Appian. All rights reserved.