plsql 除錯 pipelined 函式

dzwaM發表於2024-03-13

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

相關文章