如何使Oracle过程返回其中包含多行的游标

CURSOR cur_result IS
  SELECT column1, column2, ...
  FROM table_name
  WHERE condition;

OPEN cur_result;

RETURN cur_result;

CREATE OR REPLACE PROCEDURE get_multi_row_cursor
  (p_param1 IN VARCHAR2, p_param2 IN NUMBER, p_result OUT SYS_REFCURSOR)
AS
  CURSOR cur_result IS
    SELECT column1, column2, ...
    FROM table_name
    WHERE condition;
BEGIN
  OPEN cur_result;
  p_result := cur_result;
END;

DECLARE
  result_cursor SYS_REFCURSOR;
  column1_value table_name.column1%TYPE;
  column2_value table_name.column2%TYPE;
BEGIN
  get_multi_row_cursor('param1_value', 2, result_cursor);
  
  LOOP
    FETCH result_cursor INTO column1_value, column2_value;
    EXIT WHEN result_cursor%NOTFOUND;
    
    -- 处理每一行数据
    -- ...
  END LOOP;
  
  CLOSE result_cursor;
END;