Re^2: Copying a Database Table Using DBI's execute

It is not a tested statement because i had and have no confidence that it will run correctly. I believe that the $mysql_data = $sql_handle->fetchall_arrayref(); statement creates a reference to an array of arrays. I do not feel confident nor knowledgeable enough to determine how to employ this structure in the execute_array statement.

Sorry to be vague. I'm so clueless here with this one statement and what execute_array expects that i find it difficult to write my request either more cogently or more coherently.

Comment on Re^2: Copying a Database Table Using DBI's execute_array Download Code

Replies are listed 'Best First'.
Re^3: Copying a Database Table Using DBI's execute_array by karlgoethebier (Abbot) on May 03, 2013 at 17:45 UTC
Ť...Sorry to be vague...ť OK, but can't you: Dump the mySQL table to CSV using mysqldump 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ť	[reply]
Re^3: Copying a Database Table Using DBI's execute_array by ww (Archbishop) on May 03, 2013 at 19:33 UTC
Still, you could create a small db -- a few columns per record and only a handful of records -- and use that db as a testbed for statements about which you're unsure. Among other things, that approach is apt to be quicker than waiting for a workable answer here (and you still won't know if it's a workable answer unless you test it, or the responder provides demo material. And, (bonus!) you get the additional experience -- right or wrong -- that will help you on your path to expertise. If you didn't program your executable by toggling in binary, it wasn't really programming!	[reply]