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:

[dbo].[chatbot_ExampleSP] 
    @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] 'abc@test.com', @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

Comments

0 comments

Please sign in to leave a comment.