REF CURSORs and Cursor Variables v11
This section discusses another type of cursor that provides far greater flexibility than the previously discussed static cursors.
ref_cursor_overview declaring_a_cursor_variable opening_a_cursor_variable fetching_rows_from_a_cursor_variable closing_a_cursor_variable usage_restrictions examples dynamic_queries_with_ref_cursors