MySQL Forums
Forum List  »  Oracle

How to insert data into Oracle db from MySQL db through PHP?
Posted by: pratik kanawade
Date: March 09, 2012 08:48AM

Hi,

I want to insert my MySQL data into Oracle database through PHP.
I can access Mysql database using mysql_conect() & Oracle database using oci_connect() through PHP.
Now How can I insert my data which is in MySQL into Oracle table. Both table structure are exactly same.
So I can use
insert into Oracle_Table(Oracle_columns....) values(Select * from MySQL_Table);
But again problem is I can't open both connections at the same time.

So has anyone done this before or anyone having any other idea..

Plz guide me...

Options: ReplyQuote


Subject
Views
Written By
Posted
How to insert data into Oracle db from MySQL db through PHP?
5529
March 09, 2012 08:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.