title: How to download PDF file from blob oracle using PHP?
body: <p>I want to download blob file from oracle, that is PDF file, this is my code to get and download file:</p>
  
  <pre><code>&lt;?php
  $conn = ocilogon('user', 'pass', '//localhost/XE');
  $sql = "SELECT PDFFILE FROM TFILE";
      $stid = ociparse($conn,$sql);
      ociexecute($stid);
      $rowResult = ocifetch($stid);
      settype($arrayResult,"array");
  if($rowResult != null){
              header("Content-Type: application/octet-stream");
              header('Content-Disposition: attachment; filename="' . OCIResult($stid,'PDFFILE') . '"');    
              header("Content-Length: " . filesize(OCIResult($stid,'PDFFILE')-&gt;load()));
              header('Content-Disposition: attachment; header("Content-Transfer-Encoding: binary\n");
      }
      ?&gt;
  </code></pre>
  
  <p>but when i run this code,i not get pdf file..
   something wrong with my code??</p>