SQL> create type TypeTestObject as object (object_id number)
  2  /
Type created
SQL> create type TypeTest as table of TypeTestObject;
  2  /
Type created
SQL> create or replace function test_func return TypeTest pipelined
  2  is
  3    t number;
  4  begin
  5    t := dbms_utility.get_time;
  6    for i in (select tao.OBJECT_NAME, tao.OBJECT_ID, tao.OBJECT_TYPE
  7                from all_objects tao)
  8    loop
  9       if dbms_utility.get_time - t > 10 then
 10          raise_application_error(-20001, 'Таймаут еррор )');
 11       end if;
 12  
 13       pipe row (TypeTestObject(i.object_id));
 14    end loop;
 15  end;
 16  /
Function created
SQL> select *
  2    from table(test_func)
  3  /
 OBJECT_ID
----------
       258
       259
       311
       313
       314
       316
       317
       319
       605
       886
       887
       889
       890
       901
       903
       905
       907
       909
       911
       913
 OBJECT_ID
----------
       915
       917
       919
       921
       923
       925
       927
       929
       931
       933
       935
       937
       939
       941
       943
       945
       947
       949
       951
       953
       955
 OBJECT_ID
----------
       957
       959
       961
       963
       965
       967
       969
       971
       973
       975
       977
       979
       981
       983
       984
       985
       987
       989
       991
       993
       995
 OBJECT_ID
----------
       997
       999
      1001
      1003
      1005
      1007
      1009
      1011
      1013
      1015
      1017
      1019
      1021
      1023
      1025
      1027
      1029
      1031
      1033
      1035
      1037
 OBJECT_ID
----------
      1039
      1041
      1043
      1044
      1045
      1047
      1049
      1051
      1053
      1055
      1057
      1059
      1061
      1063
      1065
      1067
      1069
select *
  from table(test_func)
ORA-20001: Таймаут еррор )
ORA-06512: на  "AGS.TEST_FUNC", line 10