#38501 [NEW]: Cann't view blob documents storage in oracle database 9i r2

From: bbarnett at fomuvel dot com Operating system: Windows XP SP2 PHP version: 5.1.5 PHP Bug Type: OCI8 related Bug description: Cann't view blob documents storage in oracle database 9i r2 Description: ------------ I have installed in my develop machine the new version 5.1.5, but when I try to view a document storage in my oracle database send me the next message: CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are But in my production server using the version PHP Version 5.2.0RC2-dev I can see all the document. Reproduce code: --------------- // Obtiene el identificador del documento que se desea desplegar $documentoview = $_REQUEST['documentoview']; // Actualiza el contador de consultas y verifica que el documento exista $consultas = "SELECT consultas FROM INTRA_DOCUMENTOS WHERE IDDOCUMENTO = ".$documentoview ; $consultados = trs_consulta($consultas,$conn); $consulta = oci_fetch_array($consultados,OCI_RETURN_NULLS); if (!$consulta){ // Devuelve a la pantalla de contenido si el documento buscado no existe header("Location: ../contenido.php",false); /* Redirigir al navegador */ } $valor = $consulta[0]+1 ; $actualiza = "update INTRA_DOCUMENTOS set consultas= consultas+1 where IDDOCUMENTO = ".$documentoview; trs_consulta($actualiza,$conn); // Inicia el despliegue del documento $documentoview = $_REQUEST['documentoview']; $query = 'SELECT DOCUMENTO,CONTENTTYPE FROM INTRA_DOCUMENTOS WHERE IDDOCUMENTO = :MYBLOBID'; $stmt = oci_parse ($conn, $query); oci_bind_by_name($stmt, ':MYBLOBID', $documentoview); oci_execute($stmt, OCI_DEFAULT); $arr = oci_fetch_assoc($stmt); $result = $arr['DOCUMENTO']->load(); header("Content-type:".$arr['CONTENTTYPE']); echo $result; oci_free_statement($stmt); oci_close($conn); -- Edit bug report at http://bugs.php.net/?id=38501&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38501&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38501&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38501&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38501&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38501&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38501&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38501&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38501&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38501&r=support Expected behavior: http://bugs.php.net/fix.php?id=38501&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38501&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38501&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38501&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38501&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38501&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38501&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38501&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38501&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38501&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38501&r=mysqlcfg