Insert Oracle Select Mysql

Hi Guys,

I am trying to insert data into an oracle table from a select of a mysql which isnt going to well :(

DB::connection('oracle')->insert("
    INSERT INTO oracle_table
    SELECT ... FROM mysql_table
");

Any ideas?

Thanks

bobbybouwmann

11 years ago

Level 88

The insert method expects an array or a model... This will not work. You will have to do two queries, first get the data, second put the data in the database

mybigman

11 years ago

Level 2

@bobbybouwmann fair enough and thanks

yajra

11 years ago

Level 26

@mybigman , i think your query is possible by setting up an oracle to mysql database link. Haven't tried it though on actual but theoretically, i think it's possible.

One link I found to implement on windows. https://hs2n.wordpress.com/2012/04/03/oracle-create-database-link-to-mysql-database/

Please or to participate in this conversation.