Oracle管道函数

drop type my_type;
drop type my_type_row;
drop function mypipelined;
create or replace type my_type_row as object (   
  fld_id number,   
  fld_row varchar2(50),  
  fld_user varchar2(50),
  fld_date varchar2(50)  
);   
create or replace type my_type as table of my_type_row; 
 
create or replace function mypipelined(v_user in varchar2)
return my_type pipelined is
  --定义类型
   v_mytype my_type_row;
begin
  for v_counts in 1 .. 20 loop
    v_mytype := my_type_row(v_counts, 'row: ' || v_counts, v_user,to_char(sysdate,'yyyy-mm-dd'));
    pipe row(v_mytype);
  end loop;
  --此处返回空
  return;
end mypipelined;