PDO连接oracle/mysql

<?php
header("Content-Type:text/html;charset=utf-8");


$dbms1='oci';
$dbName1='192.168.13.8:1521/orcl';
$user1='iea3';
$pass1='123456';
$dsn1 = "$dbms1:dbname=$dbName1; charset=UTF8";


$dbms2='mysql';
$dbName2='my_db2';
$user2='root';
$pwd2='123456';
$host2='localhost';
$dsn2="$dbms2:host=$host2;dbname=$dbName2;charset=UTF8";


try{
$pd1=new PDO($dsn1,$user1,$pass1);
$pd2=new PDO($dsn2,$user2,$pwd2);
$pd1->query("set names utf8");
$pd2->query("set names utf8");


   $query1="select ARTIID,BT,BTQ,BTH,QY,ZD,XJ,NR,
 to_char(XSSJ,'yyyy-MM-dd HH24:mi:ss') as XSSJ,TSTAMP,CATEID,YWID from TB_IEA_FNP_ARTICLE where rownum<50";
$result1=$pd1->prepare($query1);
$result1->execute();
while ($res1=$result1->fetch(PDO::FETCH_ASSOC) ) {
is_resource($res1['NR']) && $res1['NR']=stream_get_contents($res1['NR']);

   $my0=$res1['ARTIID'];
   $my1=addslashes($res1['BT']);
   $my2=$res1['BTQ'];
   $my3=$res1['BTH'];
   $my4=addslashes($res1['QY']);
   $my5=$res1['ZD'];
   $my6=addslashes($res1['XJ']);
   $my7=addslashes($res1['NR']);
   $my8=$res1['XSSJ'];
   $my9=$res1['TSTAMP'];
   $my10=$res1['CATEID'];
   $my11=$res1['YWID'];
   
   echo $my7;
$query2="insert into ora_my(artiid,bt,btq,bth,qy,zd,xj,nr,xssj,tstamp,cateid,ywid) values
('".$my0."','".$my1."','".$my2."','".$my3."','".$my4."','".$my5."','".$my6."','".
$my7."','".$my8."','".$my9."','".$my10."','".$my11."')";

$result2=$pd2->prepare($query2);
$result2->execute();
}

$pd1=null;
$pd2=null;
}catch(PDOException $e) {
die("Error:".$e->getMessage()."</br>");
}




/*try{


$pd->query("set names 'utf8'");
$query="select * from province";
$query1="delete  from province where id =6";
$query2="insert into  province values(6,'AAA')";
$query3="update  province set p_name='BBB' where id=6";
$result=$pd->prepare($query4);
$result->execute();
print_r($result);
//$result=$pdo->query($query);
//$rs=$result->fetch(PDO::FETCH_ASSOC);
//print_r($rs);
while ($res=$result->fetch(PDO::FETCH_ASSOC) ) { //SELECT
    print_r($res);
}
}catch(Exception $e) {
echo $e->getMessage()."错误信息";
}*/
//$db=null;
?>