<?php
$dbh1 = new PDO('mysql:host=localhost;dbname=mysql', 'logn', 'haslo');
$dbh2 = new PDO('oci:host=199.199.9.99;dbname=oracle', 'login', 'login');
?>

$stmt2 = $dbh2->prepare("SELECT numer_zlecenia, uwagi FROM tabela1 ");
$stmt2->execute();
$arrValues2 = $stmt2->fetchAll(PDO::FETCH_ASSOC);

mysql_query('INSERT INTO MYSQL.tabela2(nr_zlec, uw) select numer_zlecenia, uwagi from ORACLE.tabela1')

$dbh2 = new PDO('oci:host=19999;dbname=baza2', 'login', 'haslo');
$stmt2 = $dbh2->prepare("SELECT numer_zlecenia FROM tabela2");

while ($data = $stmt2->fetchObject()){
$var1 = $data->numer_zlecenia;            
$dbh1 = new PDO('mysql:host=localhost;dbname=baza1', 'login', 'haslo');
$sql = "INSERT INTO tabela1 (nr_zlec) VALUES (':wart')";
$x = $dbh1->prepare($sql);
$x->execute(array(':wart'=>$var1));
    }

<?php
try{
$dbh2 = new PDO('oci:host=188.188.7.88;dbname=test', 'log', 'haslo');
$dbh2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt2 = $dbh2->query("SELECT numer_zlecenia FROM zlecenia_produkcyjne");
$stmt2->execute();

//$data = $stmt2->fetchAll(PDO::FETCH_ASSOC);


$dbh1 = new PDO('mysql:host=localhost;dbname=baza1', 'log1', 'haslo');
$dbh1->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

while ($data = $stmt2->fetchAll(PDO::FETCH_ASSOC)){
$variable1 = $data->numer_zlecenia;            
$sql = "INSERT INTO zlecenia_carbo (nr_zlec) VALUES (:wart)";
$q = $dbh1->prepare($sql);
$q->execute(array(':wart'=>$variable1));

}
$stmt2 -> closeCursor();

//wyswietlanie tabeli oracle
/*
foreach ($data as $row2){
foreach ($row2 as $key2 => $val2){
print "$val2";
}
print "\n";
}
*/
}

//bledy
catch(PDOException $e)
{
    print_r( $e->getTrace() );
        print_r( $e->getMessage() );
        print_r( $e->getCode() );
        
}

?>