本来以为动态语句只能返回类似int、varchar2这种类型，今天测试了下，发现还支持游标，现测试如下：

创建返回游标的函数：
create or replace function testf return sys_refcursor as
    v_refcur sys_refcursor;
begin
    open v_refcur for
    select * from test;
   
    return v_refcur;
end;

测试动态语句返回游标到变量的情况：
declare
     type tbl_numlist is table of pls_integer;
     v_numlist tbl_numlist;
     v_refcur sys_refcursor;
 begin
    --方法1：
     execute immediate 'select testf() from dual' into v_refcur;
    
     fetch v_refcur bulk collect into v_numlist;
    
     for i in 1 .. v_numlist.count loop
         dbms_output.put_line(v_numlist(i)); 
     end loop;
     close v_refcur;
    
    --方法2：
    execute immediate 'begin :1 := testf(); end;' using out v_refcur;
   
    fetch v_refcur bulk collect into v_numlist;
   
    for i in 1 .. v_numlist.count loop
        dbms_output.put_line(v_numlist(i)); 
    end loop;
    close v_refcur;
 end;