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