select * from v$version;

create or replace type an_array as table of varchar2(32767);
/

create or replace package tst_array_pipe_bug is
  function get_array return an_array;
  function get_array_pipe return an_array pipelined;
end;
/

create or replace package body tst_array_pipe_bug is
  function get_array return an_array is
  begin
    return an_array('a');
  end;
  function get_array_pipe return an_array pipelined is
    l_results an_array := an_array();
  begin

    for i in 1 .. 10 loop
      -- l_results.delete; -- this one causes exception when i > 1 second row
      l_results := get_array();
      dbms_output.put_line('l_results.count='||lpad(l_results.count,2)||' (should be l_results.count=1)' );
      for j in 1 .. l_results.count loop
        pipe row(l_results(j));
      end loop;
    end loop;
    return;
  end;
end;
/

declare
  l_result an_array;
begin
  select *
    bulk collect into l_Result
    from table(tst_array_pipe_bug.get_array_pipe());
    dbms_output.put_Line('returned l_result.count='||l_result.count);
end;
/

BANNER                                                                         
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production       
PL/SQL Release 11.2.0.2.0 - Production                                          
CORE 11.2.0.2.0 Production                                                        
TNS for Linux: Version 11.2.0.2.0 - Production                                  
NLSRTL Version 11.2.0.2.0 - Production                                          


Type AN_ARRAY compiled


Package TST_ARRAY_PIPE_BUG compiled


Package body TST_ARRAY_PIPE_BUG compiled


PL/SQL procedure successfully completed.

l_results.count= 1 (should be l_results.count=1)
l_results.count= 2 (should be l_results.count=1)
l_results.count= 3 (should be l_results.count=1)
l_results.count= 4 (should be l_results.count=1)
l_results.count= 5 (should be l_results.count=1)
l_results.count= 6 (should be l_results.count=1)
l_results.count= 7 (should be l_results.count=1)
l_results.count= 8 (should be l_results.count=1)
l_results.count= 9 (should be l_results.count=1)
l_results.count=10 (should be l_results.count=1)
returned l_result.count=55