plsql 调试 pipelined 函数

 

 

DECLARE      
  result pkg_userinfo.ty_userinfo_table;
BEGIN

  FOR rec IN (SELECT *
                FROM TABLE (pkg_userinfo.fn_get_userinfo_rows(:P_USER_ID))             )
  LOOP
    dbms_output.put_line('another step : ' || rec.u_id);
  END LOOP;

END;

 

 

https://stackoverflow.com/questions/35128472/how-to-debug-a-pipelined-function-in-pl-sql-developer/35128999

posted @ 2024-03-13 10:20  dzwaM  阅读(16)  评论(0编辑  收藏  举报