ID: 38669 Updated by: [EMAIL PROTECTED] Reported By: hhieber at softsolutions dot de -Status: Open +Status: Closed Bug Type: OCI8 related Operating System: W2K3 PHP Version: 5.1.6 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [2006-08-31 12:15:54] 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:06:06] [EMAIL PROTECTED] 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
