Displaying result-sets produced by a Stored Procedure

A Stored Procedure can return data in various ways:

as INOUT or OUT parameters
as a set of data, or multiple sets of data
for some databases (such as Snowflake) Procedures return data as a Return parameter. In this respect, Procedures are similar to Functions.

When there are INOUT or OUT parameters, for most databases these will be returned and displayed in Value column in the grid This is discussed in more detail in Running a Procedure with INOUT, OUT and RETURN parameters.

When the Procedure returns a set of data, by default this will be displayed in grid/s at the bottom of the window.

RunProcedure_results1

The Grid menu option determines where the returned data will be displayed.

when Show Grid is selected (the default), the data will be displayed at the bottom of the Run Procedure window. When this option is not selected, the data will be displayed in separate Data Display windows
by default, when a procedure is run, any existing grids as the bottom of the Run Procedure window are cleared. When Display Multiple Grids is selected, prior grids are not cleared.
Clear Grids will remove all grids from the window.

Advanced Query Tool