AnsweredAssumed Answered

Operand type clash: nvarchar is incompatible with StoreTableVariable

Question asked by sujith.vm901110 on Oct 26, 2016
Latest reply on Oct 27, 2016 by redhatva

Hello,

Below is the details error description I have got , when I tried to call a SQL server Stored Procedure from Boomi.

 

Error Description::

"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

go 

 

Outcomes