Stored Procedure with Table-Valued parameters on external MS-SQL database


Does OutSystems support executing stored procedures on an external MS-SQL database which have a table-valued parameter?

Or do I have to create an extension to accomplish this?


Thanks for your reply Stacey. 

It's still not clear whether we can pass a Table-Valued parameter to the stored procedure as in this code:

// Configure the command and parameter.  

SqlCommand insertCommand = new SqlCommand(sqlInsert, connection);  

SqlParameter tvpParam = insertCommand.Parameters.AddWithValue("@tvpNewCategories", addedCategories);  

tvpParam.SqlDbType = SqlDbType.Structured;  

tvpParam.TypeName = "dbo.CategoryTableType";