Hi everyone,
I'm developing an Ensemble process that sends user data from a Business Process to a Business Operation using EnsLib.SQL.OutboundAdapter. The operation is supposed to call a stored procedure on a SQL Server.
The stored procedure expects 3 parameters:
@FirstName, @LastName, and @Email.
The procedure works fine when executed directly from SQL Server Management Studio.
However, when I trigger it via Ensemble, I get the following error:
[SQL Server] Incorrect syntax near 'email@domain.com'
hat is the proper way to use ExecuteProcedure or ExecuteUpdateParmArray to safely pass parameters to a SQL Server stored procedure using EnsLib.SQL.OutboundAdapter?
If anyone has a working example of a Business Operation calling a SP with parameters – that would be a huge help 🙏
Thanks in advance!