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; }