Esempio n. 1
0
 public function insUpdAssetSources($customerId, array $sources)
 {
     $sourcesXml = new Base_Def_XmlBuilder('SOURCES');
     $sourcesXml->addIteration('idSource', new Base_Def_XmlBuilder('ID_SOURCE'))->setIterationValue('idSource', $sources);
     $xml = new Base_Def_XmlBuilder('SYNCH_API');
     $xml->addTag('ID_CUSTOMER')->setTagsValues(array('ID_CUSTOMER' => $customerId));
     $xml->addTag($sourcesXml);
     $inputXml = $xml->getXml();
     $outputArr = array();
     $outputClob = null;
     $result = null;
     $xmlHead = $this->getXmlHead();
     $bindArray[':zm_head'] = $xmlHead;
     $bindArray[':in_clob'] = $inputXml;
     $bindArray[':out_clob'] =& $outputClob;
     $bindArray[':result{output}'] =& $result;
     $query = "begin :result := noble.pcg_one_api.execute_function('insupd_asset_sources_ex', :zm_head, :in_clob, :out_clob); end;";
     $this->_executeQuery($query, $bindArray, true);
     $simpleXml = simplexml_load_string($outputClob);
     if ($simpleXml) {
         $outputArr = $this->xml2Array($simpleXml);
     }
     return $outputArr;
 }