create type TypetObjectTest as object 
(
 id  number,
type varchar2(10)
);
create type TypetList as table of TypetObjectTest;
CREATE OR REPLACE function TEST_SCHEMA2.FunctionTest(pObject_type in varchar2)
          return TypetList pipelined 
          AUTHID CURRENT_USER
          as 
sql_text varchar2(1500):='SELECT id,type from MYPIPE';
  type tCur_id is REF CURSOR;
  Cur_id tCur_id;
   f_id  number;
    f_type varchar2(10);     
begin
OPEN Cur_id FOR sql_text ;
LOOP 
FETCH Cur_id INTO f_id,f_type;
EXIT WHEN Cur_id%NOTFOUND; 
 pipe row (TypetObjectTest(f_id,f_type));    
  end loop;
  close Cur_id;
 return;
end;
GRANT execute on TEST_SCHEMA2.FunctionTest  to TEST_SCHEMA;

/

create TABLE MYPIPE
(
 id  number,
type varchar2(10)
);
select * from table(TEST_SCHEMA2.FunctionTest('')) t