php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #38669 PHP crashes at $row[$blobname]->load()
Submitted: 2006-08-31 11:59 UTC Modified: 2006-08-31 12:17 UTC
From: hhieber at softsolutions dot de Assigned:
Status: Closed Package: OCI8 related
PHP Version: 5.1.6 OS: W2K3
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: hhieber at softsolutions dot de
New email:
PHP Version: OS:

 

 [2006-08-31 11:59 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-08-31 12:06 UTC] tony2001@php.net 
Please try OCI8 version 1.2.2.
http://pecl4win.php.net/ext.php/php_oci8.dll
 [2006-08-31 12:15 UTC] hhieber at softsolutions dot de 
Hi Tony,

yes, the PECL verions 1.2.2 works (as I already stated).
Whats the difference to PHP5.1.6?
 [2006-08-31 12:17 UTC] tony2001@php.net 
PHP 5.1.6 contains (almost) only security related fixes, so OCI8 is quite outdated there.
Though, OCI8 1.2.2 == OCI8 in 5.2-CVS.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Jun 03 02:01:26 2025 UTC