How to pass data to a stored procedure that has a user defined table type as an input parameter?

I have a stored procedure that I would like to call via Cognigy.

The signature of the stored procedure looks somewhat like this:

    @emailId nvarchar(255),
    @example chatbot_UserDefinedTableType readonly

When executing the SP within SSMS I pass the data as follows:

DECLARE @example chatbot_UserDefinedTableType
INSERT INTO @example VALUES (01, 2021)
INSERT INTO @example VALUES (01, 2022)

EXEC [chatbot_ExampleSP] '', @example

Could someone please help me achieve the same via Cognigy?


Please note: the number of insert statements are not fixed. It depends on the user input.

Didn't find what you were looking for?

New post
Was this post helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.