#!/usr/local/bin/php writeTemporary($strLOB) ) { $e = ocierror($stmt); logMessage("Error Reading in ${INSTALL_DIR}/sql/$lob_file : ", $log_fp); oci_rollback($conn); continue; } // Execute the statement using , OCI_DEFAULT - as a transaction if ( !oci_execute($stmt, OCI_DEFAULT) ) { $e = ocierror($stmt); logMessage("SQL: $sql :\n\n", $log_fp); logMessage("Error executing: ".$e['message'], $log_fp); oci_rollback($conn); } else { logMessage("Inserting template $template_type\n", $log_fp); oci_commit($conn); } $myLOB->free(); $myLOB->close(); } else { foreach ($all_rows as $row) { $template_id = $row[0]; // Write New field oci_free_statement($stmt); $sql = "UPDATE TEMPLATE SET XSL_TEMPLATE=TO_NCLOB(:xsl_lob) WHERE ID = '$template_id' "; $stmt = oci_parse($conn, $sql); // Creates an "empty" OCI-Lob object to bind to the locator $myLOB = oci_new_descriptor($conn, OCI_D_LOB); // Bind the returned Oracle LOB locator to the PHP LOB object oci_bind_by_name($stmt, ":xsl_lob", $myLOB, -1, OCI_B_CLOB); // Now write a temporary CLOB that oracle will convert to a NCLOB $strLOB=file_get_contents("${INSTALL_DIR}/sql/$lob_file"); $strLOB=str_replace('-RESELLER_URL-', $res_url, $strLOB); $strLOB=str_replace('-OWNER_URL-', $own_url, $strLOB); $strLOB=str_replace('-PBX_URL-', $pbx_url, $strLOB); $strLOB=str_replace('-CALLSHOP_URL-', $callshop_url, $strLOB); if ( !$myLOB->writeTemporary($strLOB) ) { $e = ocierror($stmt); logMessage("Error Reading in ${INSTALL_DIR}/sql/$lob_file : ", $log_fp); oci_rollback($conn); continue; } // Execute the statement using , OCI_DEFAULT - as a transaction if ( !oci_execute($stmt, OCI_DEFAULT) ) { $e = ocierror($stmt); logMessage("SQL: $sql :\n\n", $log_fp); logMessage("Error executing: ".$e['message'], $log_fp); oci_rollback($conn); } else { logMessage("Updating template $template_type\n", $log_fp); oci_commit($conn); } $myLOB->free(); //$myLOB->close(); } } // Free resources oci_free_statement($stmt); } else { $e = ocierror($stmt); logMessage("SQL: $sql :\n\n", $log_fp); logMessage("Error executing $lob_file - ".$e['message'], $log_fp); oci_rollback($conn); exit(1); } } // Close down oracle connection oci_close($conn); logMessage("Templates Finished\n", $log_fp); #Close Files if(!fclose($log_fp)) { echo "Error! Couldn't close log file."; } exit(0); ?>