I have a stored procedure (MySQL) that takes in one value, and returns a list of items that match the input value. In testing outside of bubble.io, this works perfectly and returns a result set. When I try and move this to bubble, there is no prompt to select the outputs of the stored procedure into variables.
Does anyone have any ideas on how to generate a temporary table/list from the stored procedure output?
Below is the procedure, the test output, and how I added it to bubble.io.
From first glance, it seems bubble.io’s only stored procedure functionality is to initiate stored procedures, and cannot read returned data unless it is parameters.
Thanks for any input y’all might have!
Edit: I could turn my stored procedure into a plain SELECT statement on bubble.io directly, but I’m afraid that would greatly affect performance once the result sets hit 100-200 rows.