in reply to Re^2: Copying a Database Table Using DBI's execute_array
in thread Copying a Database Table Using DBI's execute_array

«...Sorry to be vague...»

OK, but can't you:

  1. Dump the mySQL table to CSV using mysqldump
  2. Bulk insert the data into Oracle

If you need to manipulate your data, you can do something in the bulk insert script or you can use a trigger and a stored procedure...

Regards, Karl

«The Crux of the Biscuit is the Apostrophe»

  • Comment on Re^3: Copying a Database Table Using DBI's execute_array