To access rows returned by a procedure, you use the FETCH statement as you did for cursors. You can execute the FETCH statement after any EXECUTE statement that executes a procedure that has output parameters.
Example
FETCH dept_proc INTO :name_var;
The FETCH FROM procedure statements must exactly match the output parameters returned by the stored procedure when it executes.
