Return Data from a Stored Procedure

If your stored procedure is returning a set of rows, it may not be displayed inside Appsmith today due to some limitations in the platform. To get around these limitations, you need to add a dummy select statement at the end of the procedure call to return the results of the procedure.

The query would look like

call test2('BA01'); 
select "dummy" as dummy where false;