create or replace type A1 as table of number;

create or replace type tA1 as object
(
  F1           number,
  member function Show(P1 number          ) return A1 pipelined,
  member function Show(P1 number,P2 number) return A1 pipelined
);

create or replace type body tA1 as

  member function Show(P1 Number) 
           return A1 pipelined
  as
  begin
    declare
      R A1;
    begin

/*
     -- R:=Show(P1,0);  --ошибка вызова PL/SQL не поддерживает вызов pipelined
      select * bulk collect into R from table(tA1(0).Show(P1,0));
      for I in R.First..R.Last loop
        pipe row(R(I));
      end loop;

     -- Данный  select + for  не нужен, управление вывода необходимо передать на Show(P1,P2)
*/

    end;
    return;
  end;

  member function Show(P1 Number,P2 Number) 
           return A1 pipelined
  as
  begin
    declare
      a number;
    begin
      for I in 1..P1+P2 loop
        pipe row(I);
      end loop;
    end;
    return;
  end;

end;


select *
  from table(tA1(0).Show(4,5));

select *
  from table(tA1(0).Show(10));