in reply to Copying a Database Table Using DBI's execute_array
Read all of execute_for_fetch as it shows you how to effectively copy data from one statement handle to another.