Below is the details error description I have got , when I tried to call a SQL server Stored Procedure from Boomi.
"Errors occurred while building or executing SQL statement: Operand type clash: nvarchar is incompatible with StoreTableVariable; Caused by: Operand type clash: nvarchar is incompatible with StoreTableVariable"
My aim is to call the stored procedure in the below fashion as we normally does::
declare @a ArticleTableVariable
insert into @a (AID) select '123'
declare @s StoreTableVariable
insert into @s(SID) select '567'
insert into @s(SID) select '890'
exec [dbo].[sp_stcheck] @s ,@a