DECLARE
   fileName  CONSTANT VARCHAR2( 32767 ) := 'c:\test.txt';
   separator CONSTANT CHAR( 1 ) := CHR( 9 );
   f     TEXT_IO.FILE_TYPE;
   
   CURSOR pipe_data IS
      SELECT * 
      FROM   TABLE(pipe_func([paramlist]));
BEGIN
   
   f := TEXT_IO.FOPEN(fileName,'w');
   
   FOR R IN pipe_data LOOP
      TEXT_IO.PUT_LINE(f,
         R.column1 || SEPARATOR ||
         R.column2 || SEPARATOR
         ...
      );
   END LOOP;   
   
   TEXT_IO.FCLOSE(f);
END;