DECLARE
  out_len INTEGER;
  TYPE curtype IS REF CURSOR;
  cur curtype;

  TYPE info_rt IS RECORD (
     v_id INTEGER,
     v_data VARCHAR(100),
     v_flags INTEGER
   );

  TYPE info_t IS TABLE OF info_rt;
  tmp_table info_t;

  BEGIN
     "dbo"."TESTPROC"@fdslink(5, 1, cur);
     LOOP
       FETCH cur
       BULK COLLECT INTO tmp_table LIMIT 1000;
       DBMS_OUTPUT.PUT_LINE('Rows fetched: ' || tmp_table.count);
       EXIT WHEN tmp_table.count = 0;
  END LOOP;
  CLOSE cur;
END; 
/
COMMIT;
ROLLBACK;

Rows fetched: 19
Rows fetched: 0
 
PL/SQL procedure successfully completed.

Copyright © 2018, Oracle and/or its affiliates. All rights reserved.