Anyone inserted data directly from Oracle 11g to MySQL?
Hi There,
We work mainly on Oracle 11g. However, there is a requirement to now connect to an external MySQL database from our company's Oracle Database. Would be trying to do this for the first time. The process would be to download the data using PL/SQL from the ORacle 11g DB and then insert the data into the MySQL DB table. Had a few questions,
1. Are there any known issues with connections between ORacle as source and MySQL as target. Anything that needs to be kept in mind?
2. How do we send the data to MySQL, I mean in PL/SQL we can have the procedure create the insert statements. But can we directly fire the insert on MySQL ? If yes, any suggestions on what the commands would be?
3.Any way to figure out if the insert was successful?
4. We might also have to do other operations like update/delete etc.
5. Any possible reference or sample code on this would also help.
Thanks