예제 #1
0
파일: Abstract.php 프로젝트: knatorski/SMS
 public function getCustomerAssets($idCustomer)
 {
     $xml = new Base_Def_XmlBuilder('SYNCH_API');
     $xml->addTag('ID_CUSTOMER')->setTagsValues(array('ID_CUSTOMER' => $idCustomer));
     $inputXml = $xml->getXml();
     $outputClob = null;
     $outputArr = array();
     $result = null;
     $bindArray[':in_clob'] = $inputXml;
     $bindArray[':out_clob {output}'] =& $outputClob;
     $bindArray[':result (OCI_BOTH)'] =& $result;
     $query = 'begin :result := noble.pcg_fo_synch_manual.FUN_fetchAssetSources(:in_clob, :out_clob); end;';
     $this->_executeQuery($query, $bindArray, true);
     $simpleXml = simplexml_load_string($outputClob);
     return (array) $simpleXml->ROW->SOURCES->ID_SOURCE;
 }