Call a stored procedure returning multiple datasets

Question

I have to call a SQLserver stored procedure that returns three tables with different columns. I defined the three structures matching the outputs. Then, added to the Output Entities/Structures the tree output structures, but the response to the test call is: "Database returned the following error: Column count doesn't match output structure attribute count".

Note that if I put only the first structure then it works and returns the first table only.

How can I get also the other result tables?

thanks

22 Apr

Vinod Patidar

Hi Mauro,

I have created a sample c# extension project to Call a stored procedure that is returning multiple datasets. Please find the attached extension for the same.

1. You need to create a database connection string in service studio.(Below is the screen for the same)

2. You need to change connection string name, stored procedure name and input/output parameter in this extension project.

You can refer below course for Extending Logic with C# Code -

https://www.outsystems.com/training/courses/117/using-c-code/

Thanks

Vinod

SP_Extension.xif

25 Apr

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines