#StoredProcedure Hi, Does anyone know how to pass a table type as par

#StoredProcedure
Hi,
Does anyone know how to pass a table type as parameter to "Execute Stored Procedure" smart service ?
Example:
create type dbo.typeTableTypeTest as table (col_a int, col_b varchar(10))
create table dbo.TableTypeTest (col_a int, col_b varchar(10))

create procedure dbo.spTableTypeTest
(@pintable dbo.typeTableTypeTest READONLY)
AS
BEGIN

INSERT INTO dbo.TableTypeTest (col_a, col_b)
SELECT col_a,col_b FROM @pintable

END

What should be the data type of "pintable" parameter in Appian in above example?
I have tried with "text" and "CDT" but in vain. I get the error:

com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: nvarchar is incompatible with typeTableTypeTest
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.

OriginalPostID-151280

OriginalPostID-151280

  Discussion posts and replies are publicly visible