1 Reply Latest reply on Mar 9, 2012 4:32 PM by Pnauduri-Oracle

    How to insert data into Oracle db from MySQL db through PHP?


      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...