ID: 36139 Comment by: gcamacho79 at yahoo dot com Reported By: max__payne at list dot ru Status: No Feedback Bug Type: OCI8 related Operating System: Win 2003 Server Standard R2 PHP Version: 5.1.2 New Comment:
"Through trial and error through comment blocks, I found that Apache crashed upon executing "OCI_PARSE($conn,$sql);", where the connection to the Oracle DB server via a local client appears to have been successful" ----------------------------------------------------------- I had the same problem and I fixed it. I recently upgraded from PHP 4.2 to PHP 5.1.2 and suddenly my PHP/Oracle scripts were not working. Apache would just crash everytime I called oci_parse(). I fixed the problem by downloading a new php_oci8.dll from this site: http://pecl4win.php.net/ext.php/php_oci8.dll My scripts started working instantly after I replaced the php_oci8.dll from the PHP 5.1.2 with the one from this website. Previous Comments: ------------------------------------------------------------------------ [2006-02-16 01:00:04] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2006-02-08 09:16:22] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.1-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.1-win32-latest.zip ------------------------------------------------------------------------ [2006-02-08 07:00:18] v_afan at fareastone dot com dot tw I am aware that the issue is reported by someone else on prior versions of PHP 5.x, and I am aware the issue is reportedly resolved, but the crash problem of the PHP 5.x SAPI for Apache appears to have risen again. I used the following code on PHP 5.1.2 (SAPI) on both Apache 2.0 (official binaries) and 2.2 (compiled SAPI module with VC .Net 2003) on Windows XP SP2, and Apache would crash with a Windows dialog box that indicates the crash. Through trial and error through comment blocks, I found that Apache crashed upon executing "OCI_PARSE($conn,$sql);", where the connection to the Oracle DB server via a local client appears to have been successful (Oracle client 8.1.7.0.0 connecting to Oracle server 8.1.7.4.0). Interestingly though, the following code does work successfully (as expected) for both Apache 2.0 and 2.2 when used in conjunction with their corresponding PHP SAPI modules from PHP 5.1.1 on the same combination of OS, compiler, oracle client and server. Thanks for the time, and I would still like to thank the PHP devs on their works on this great program. --------------CODE used to trigger the crash on PHP 5.1.2-- <? $un = 'someone'; $pw = 'foo'; $db = 'somedb'; $conn = oci_connect($un, $pw, $db); if (!$conn) { echo("DB Connection failed!"); exit; } $dev_id = $_POST["dev_id"]; $sql = 'SELECT FOO FROM SOME_TABLE WHERE DEV_ID = :DEV'; $qry = OCI_PARSE($conn,$sql); OCI_BIND_BY_NAME($qry, ":DEV", $dev_id, -1); OCI_EXECUTE($qry); ?> ------------------------------------------------------------------------ [2006-02-02 01:00:04] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2006-01-25 08:25:22] max__payne at list dot ru I use client Oracle 9i client libraries. They are not compatible with PHP 5.1.2? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/36139 -- Edit this bug report at http://bugs.php.net/?id=36139&edit=1