try {
    $conAD = new PDO('oci:dbname=//localhost:1521/xe/ORCL', 'wms_eadi', 'wms_eadi');
    $conAD->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}

//$db_connectAG = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.220.43)(PORT=1521)) (CONNECT_DATA=(SID=alcisagprd)))';
//$db_userAG = 'core_11_1';
//$db_passAG = 'T3cn1c05p';
//$db = "oci:dbname=alcisagprd";
//$conAG = oci_connect($db_user,$db_pass,$db_connectAG,'AL32UTF8');


//$conAG = new PDO("oci:dbname=".$db_connectAG,$db_userAG,$db_passAG);

//$db_connectAD = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.220.32)(PORT=1522)) (CONNECT_DATA=(SID=ALCISSTB)))';
//$db_userAD = 'wms_eadi';
//$db_passAD = 'wms_eadi';
//$conAD = oci_pconnect($db_userAD,$db_passAD,$db_connectAD,'AL32UTF8');
//$conAD = oci_connect("wms_eadi","wms_eadi","ALCIS_NEW"); conexão alternativa
//$conAG = oci_connect('core_11_1', 'T3cn1c05p', 'ALCISAGPRD','AL32UTF8');


//$AD = oci_parse($conAD,"select k.suchbegriff from KLIENTEN k where (k.suchbegriff = '".$cnpj."' or k.suchbegriff = '".$tb_cnpj."')");
//oci_execute($AD);
//$lineAD = oci_fetch_all($AD, $res);

$AD = $conAD->query("select k.suchbegriff from KLIENTEN k where (k.suchbegriff = '".$cnpj."' or k.suchbegriff = '".$tb_cnpj."')");
$AD->execute();
$lineAD = $AD->rowCount();

$AG = $conAG->query("select k.suchbegriff from KLIENTEN k where (k.suchbegriff = '".$cnpj."' or k.suchbegriff = '".$tb_cnpj."')");
$AG->execute();
$lineAG = $AD->rowCount();

//$AG = oci_parse($conAG,"select k.suchbegriff from KLIENTEN k where (k.suchbegriff = '".$cnpj."' or k.suchbegriff = '".$tb_cnpj."')");
//oci_execute($AG);
//$lineAG = oci_fetch_all($AG, $res);

if($lineAD > 0 && $lineAG > 0){
    header("Location: clientes/indexFull.php");
}else if($lineAD > 0 && $lineAG == 0){
    header("Location: clientes/index.php");
}else if($lineAG > 0 && $lineAD == 0){
    header("Location: clienteAG/indexAG.php");
}else{
    echo "<script>
            alert('CNPJ NÃO SE ENCONTRADO NA BASE DADOS\nFAVOR ENTRAR EM CONTATO COM ATENDIMENTO');
            location.href='formulario_cadastroTeste.php';
         </script>";
}