create or replace function f 
  return int as 
begin
  dbms_lock.sleep(5);
  return 1;
end;
/

create or replace procedure p (cur out sys_refcursor) is
begin
  open cur for 
    select f from dual;
end p;
/

SQL> set timing on
SQL> select f from dual;

         F
----------
         1

Elapsed: 00:00:05.47
SQL>
SQL> exec p(:c);

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.35
SQL>
SQL> print :c;

         F
----------
         1

Elapsed: 00:00:05.46

SQL> create or replace type nums as object (f int);
  2  /

Type created.

Elapsed: 00:00:00.33
SQL> create or replace type nums_t as table of nums;
  2  /

Type created.

Elapsed: 00:00:00.33
SQL>
SQL> create or replace function pipeline
  2    return nums_t pipelined as
  3  begin
  4    for rws in (
  5      select f from dual
  6    ) loop
  7      pipe row(nums(rws.f));
  8    end loop;
  9
 10    return ;
 11  end;
 12  /

Function created.

Elapsed: 00:00:00.33
SQL>
SQL> select * from table(pipeline());

         F
----------
         1

Elapsed: 00:00:05.47