Re: Copying a Database Table Using DBI's execute

Not to endorse or deny your conclusion, but how did you arrive at "...this next and last statement is probably really wrong." Is there some substantive reason -- like errors or warnings or your computer puking out blue flames -- that leads you to your belief?

IOW, details ... all the details, help us to help you.

If you didn't program your executable by toggling in binary, it wasn't really programming!

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

Replies are listed 'Best First'.
Re^2: Copying a Database Table Using DBI's execute_array by plendid (Sexton) on May 03, 2013 at 17:24 UTC
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.	[reply] [d/l]
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]