Create table tb_test (id number, description varchar2 (50))

create or replace package pkg_test is  
    cursor cur_test is  
        select *  
        from tb_test  
        where 1=2;  
    type typ_cur_test is table of cur_test%rowtype;  
    function fn_test(p_rows in number) return typ_cur_test pipelined;  
end;

create or replace package body pkg_test is  
    function fn_test(p_rows in number) return typ_cur_test pipelined as  
    l_tab typ_cur_test := cur_typ_test();  
    begin  
        for i in 1..p_rows loop l_tab.extend;  
            l_tab(i).Id := i;  
            l_tab(i). Description := 'test';  
            pipe roe(l_tab(i));  
        end loop;  
    return ;  
    end;  
end pkg_test;

create or replace package body pkg_test is  
    function fn_test(p_rows in number)  
    return typ_cur_test pipelined as  
    l_tab typ_cur_test := cur_typ_test();  
    begin  
        for i in 1..p_rows loop l_tab.extend;  
            l_tab(i).Id := i;  
            l_tab(i). Description := 'test';  
            pipe row(l_tab(i));  
        end loop;  
    return ;  
    end;  
end pkg_test;

create or replace package body pkg_test is  
    function fn_test(p_rows in number)  
    return typ_cur_test pipelined as  
    l_tab typ_cur_test := typ_cur_test();  
    begin  
        for i in 1..p_rows loop l_tab.extend;  
            l_tab(i).Id := i;  
            l_tab(i). Description := 'test';  
            pipe row(l_tab(i));  
        end loop;  
    return ;  
    end;  
end pkg_test;

Select * from table(pkg_test.fn_test(2))