create or replace function f_pipe(s number) return t_table pipelined as v_obj_table obj_table; begin for i in 1..s loop v_obj_table := obj_table(i,to_char(i*i)); pipe row(v_obj_table); end loop; return; end f_pipe;
create or replace function f_normal(s number) return t_table as rs t_table:= t_table(); begin for i in 1..s loop rs.extend; rs(rs.count) := obj_table(rs.count,'name'||to_char(rs.count)); --rs(rs.count).name := rs(rs.count).name || 'xxxx'; end loop; return rs; end f_normal;