Need advice on transferring data from a remote database

I need to transfer some data from the remote database into my local one. Using the COPY command in the SQL*Plus is not an option. I have to use a procedure with the following code:
 for rec in (select * from table1_at_linkToRemoteDB) loop    <do something with rec.*>
 end loop;
This works fine, but it is too slow. Maybe anyone knows how can I speed up the transfer, maybe I should not use a cursor? Any comments are very wellcome.

Thank you,
Alex

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 24 1998 - 05:44:24 CDT