How to call Stored Procedure from BPM

[Dikshat (DK)]

Hi,

I have a stored procedure in SQL Server that take 1 parameter and return some result. So can anybody give me the syntax how can I call this stored procedure from Epicor BPM and get that data into some variable?

[Mark_Wonsil]

A search for “store procedure” turns up this post:

Call store procedure in Kinetic Function not working

I am using function in Kinetic 2022.2 to call a SQL Store Procedure using the System.Data.Sqlclient. I can’t get it to work anymore. It is works fine in Epicor 10.2.700.xx. Is anyone know another way to call Store Procedure using Kinetic Function?