Hi, I need some help with the following problem:
I have files stored in an Oracle 10g database within blob fields and I want to download this files from a browser through PHP. My problem is that I'm using PHP4 and I can't update to PHP5. The only Lob function I have is Load(). However this function seems to have a 1mb limit when loading the blob. So, files above 1mb aren't fully written, and I get "corrupt file" or "end of file corruption" errors when I try to open them after downloading.
Is it possible to increase the load size limit somehow? any other possibility?
This is part of the code for downloading (the $con object is from a class I put above oci, but it doesn't do anything special, just replicates the oci funcions):
ob_start();
...
$dml_query = "SELECT NAME,CONTENT FROM CMN_FILES
WHERE FILE_ID = 128";
$stmt = $con->executeQuery($dml_query);
$result = $con->getArrayQueryResult($stmt);
$name = $result['NAME'];
...
ob_end_clean();
header("Content-Disposition: attachment; filename=$name");
echo $result['CONTENT']->load();
Thank you in advance,
Steven
