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.
Comments
0 comments