#38669 [Fbk->Opn]: PHP crashes at $row[$blobname]->load()
| From: | hhieber at softsolutions dot de | Date: | Thu, 31 Aug 2006 12:15:54 +0000 |
| Subject: | #38669 [Fbk->Opn]: PHP crashes at $row[$blobname]->load() | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-101569@lists.php.net to get a copy of this message | ||
ID: 38669
User updated by: hhieber at softsolutions dot de
Reported By: hhieber at softsolutions dot de
-Status: Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: W2K3
PHP Version: 5.1.6
New Comment:
Hi Tony,
yes, the PECL verions 1.2.2 works (as I already stated).
Whats the difference to PHP5.1.6?
Previous Comments:
------------------------------------------------------------------------
[2006-08-31 12:06:06] tony2001@php.net
Please try OCI8 version 1.2.2.
http://pecl4win.php.net/ext.php/php_oci8.dll
------------------------------------------------------------------------
[2006-08-31 11:59:21] hhieber at softsolutions dot de
Description:
------------
I upgraded from PHP5.0.4 to 5.1.6.
PHP with Oracle 9 no longer worked due to missing function
OCILobRead2() in oci.dll, so I upgraded to Oracle 10.2.0
This works fine until trying to read a BLOB with
$row[$blobname]->load(). This results in
"PHP has encountered an Access Violation at 7C8..."
Problem is also true with PHP5.1.4
Replacing php_oci8.dll with PECL version as of PHP_5.1.2 finally
works.
Any ideas, why to use the PECL version?
BTW: calling $row[$blobname]->size() is ok ever.
Reproduce code:
---------------
function get_blob_data($table, $keyname, $keyvalue, $blobname)
{
$sql = "SELECT * FROM " . strtolower($table) . " WHERE " . $keyname .
" = " . $keyvalue;
$stmt = ociparse($this->conn,$sql);
ociexecute($stmt)
or die ("Unable to execute query\n");
$row = oci_fetch_assoc($stmt);
return ($row[$blobname]->load());
}//endfunction
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38669&edit=1