Oracle FETCH

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.