Result Set From Stored Procedure. Insert Stored Procedure result into Temporary Table in SQL Example 1. For large result sets the stored procedure execution will not continue to the next statement until the result set has been completely sent to the client.
The application can then issue fetch requests to read the rows of the result set cursor. Using Unbounded SELECT Statements. Now let us see two different scenarios where we will insert the data of the stored procedure directly into the table.
MySQL stored procedures but not functions can return result sets to the calling program though not unfortunately directly to another stored procedure.
In Oracle you can use SYS_REFCURSOR type to pass result sets between stored procedures. The following stored procedure p_dept will return department names in sys_refcursor p_result from the department table where the department number is less than or equal to the parameter value. Specify WITH RETURN TO CALLER or WITH RETURN for the stored procedure to return the result sets to both the caller of the target procedure and to the target procedure the procedure that opened the cursor. As its been mentioned in the question its hard to define the 80 column temp table before executing the stored procedure.