如何使用pipeline function获得实时输出

create or replace type MsgType as table of varchar2(4000);/create or replace function f_pipeline_testreturn MsgTypePIPELINEDasbegin    for i in 1 .. 10    loop        pipe row( 'Iteration ' || i || ' at ' || systimestamp );        dbms_lock.sleep(1);    end loop;    pipe row( 'All done!' );    return;end;/

SQL> set arraysize 1SQL> select * from table( f_pipeline_test );COLUMN_VALUE-----------------------------------------------------Iteration 1 at 14-FEB-08 02.13.18.273988000 PM +08:00Iteration 2 at 14-FEB-08 02.13.19.275988000 PM +08:00Iteration 3 at 14-FEB-08 02.13.20.277767000 PM +08:00Iteration 4 at 14-FEB-08 02.13.21.279591000 PM +08:00Iteration 5 at 14-FEB-08 02.13.22.281366000 PM +08:00Iteration 6 at 14-FEB-08 02.13.23.283189000 PM +08:00Iteration 7 at 14-FEB-08 02.13.24.283965000 PM +08:00Iteration 8 at 14-FEB-08 02.13.25.285785000 PM +08:00Iteration 9 at 14-FEB-08 02.13.26.286570000 PM +08:00Iteration 10 at 14-FEB-08 02.13.27.288387000 PM +08:00All done!

create or replace function f_pipeline_testdmlreturn MsgTypePIPELINEDasbegin    for i in 1 .. 10    loop        insert into test values(1);        pipe row( 'insert into test values( ' || i || ') success at ' || systimestamp );        dbms_lock.sleep(1);    end loop;    pipe row( 'All done!' );    return;end;/SQL>  select * from table( f_pipeline_testdml ); select * from table( f_pipeline_testdml )                      *ERROR at line 1:ORA-14551: cannot perform a DML Operation inside a queryORA-06512: at "NING.F_PIPELINE_TESTDML", line 8create or replace function f_pipeline_testdmlreturn MsgTypePIPELINEDasPRagma autonomous_transaction;beginfor i in 1 .. 10loopinsert into test values(1);commit;pipe row( 'insert values ' || i || ' success at ' || systimestamp );dbms_lock.sleep(1);end loop;pipe row( 'All done!' );return;end;/SQL> select * from table( f_pipeline_testdml );COLUMN_VALUE--------------------------------------------------------------------------------insert values  1  success at 14-FEB-08 02.16.47.855158000 PM +08:00insert values  2  success at 14-FEB-08 02.16.48.865559000 PM +08:00insert values  3  success at 14-FEB-08 02.16.49.867377000 PM +08:00insert values  4  success at 14-FEB-08 02.16.50.873154000 PM +08:00insert values  5  success at 14-FEB-08 02.16.51.874942000 PM +08:00insert values  6  success at 14-FEB-08 02.16.52.880781000 PM +08:00insert values  7  success at 14-FEB-08 02.16.53.882543000 PM +08:00insert values  8  success at 14-FEB-08 02.16.54.894348000 PM +08:00insert values  9  success at 14-FEB-08 02.16.55.896153000 PM +08:00insert values  10 success at 14-FEB-08 02.16.56.901904000 PM +08:00All done!11 rows selected.

create or replace function f_pipeline_testdmlreturn MsgTypePIPELINEDaspragma autonomous_transaction;beginfor i in 1 .. 10loopinsert into test values(1);pipe row( 'insert values ' || i || ' success at ' || systimestamp );dbms_lock.sleep(1);end loop;pipe row( 'All done!' );commit;return;end;/SQL> select * from table( f_pipeline_testdml );select * from table( f_pipeline_testdml )                     *ERROR at line 1:ORA-06519: active autonomous transaction detected and rolled backORA-06512: at "NING.F_PIPELINE_TESTDML", line 10

ALTER SYSTEM SET EVENT = "10946 trace name context forever, level 8" scope=spfile;