How to use stored procedure in the External Database connector
0
Hi Experts: I want to call a stored procedure to query data instead of writing individual query for each condition, because I only need to send a parameter to the procedure and let this procedure do the conditional select. Here is the screen shot of my mendix, after I run the query, the Response data is correct, but when I go to the Response structure, it had an extra entity which the attribute is no_of_rows_affected. Meanwhile, when I use this query in the microflow, it returns entity "arena_get_cm_supplier_list" which the attribute is no_of_rows_affected not the real list. In the stored proc I have already added "SET NOCOUNT ON" by the way. I am not sure if I am using it correctly. here is my stored proc:
asked
Bruce He
1 answers
0
To retrieve a list of records for a result set entity, use the "Retrieve Over Association" activity and select the association from the output variable of the "Query External Database" activity.