ID: 28924 Updated by: [EMAIL PROTECTED] Reported By: ben at grinvalds dot net -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows XP PHP Version: 5.0.0RC3 New Comment:
Could you please try latest CVS snapshots from http://snaps.php.net? And could you try to run the code from console too? Does it crash? Previous Comments: ------------------------------------------------------------------------ [2004-06-30 18:15:52] ben at grinvalds dot net I've been doing some more investigation. When I changed my php configuration in the Apache http.conf from sapi to cgi, the problem goes away. Looks like the problem is related to the sapi module. ------------------------------------------------------------------------ [2004-06-29 16:11:23] ben at grinvalds dot net I have included a script which causes a reference memory error to occur more frequently. If you run this script three or four times back to back you will get the error. Ben <?php class Test { var $_results; var $_ncount; function display() { $conn = oci_connect("scott", "tiger", "host_name"); $stmt = oci_parse($conn, "select ENAME from emp"); oci_execute($stmt); $this->_ncount = oci_fetch_all($stmt, $this->_results); oci_free_statement($stmt); oci_close($conn); for ($i = 0; $i < $this->_ncount; $i++) { echo $this->_results["ENAME"][$i]; }}} $test = new Test(); $test->display(); ?> ------------------------------------------------------------------------ [2004-06-25 16:56:39] ben at grinvalds dot net Description: ------------ I have been testing my code in PHP5 and have been getting regular Apache.exe Application errors. When I run the script below a few times, I will consistantly get reference memory errors. Even after I re-boot my system. My application makes many calls to an Oracle database. I'm not sure if this is specifically related to OCI or if it is a more general PHP memory issue. Environment: OS: Windows XP Professional with SP1 Server: Apache 1.3.31 (Win32) DB: Oracle 8.4.7 Reproduce code: --------------- <?php $conn = oci_connect("scott", "tiger", "your_host_name"); for ($p=0; $p <= 500; $p++) { $stmt = oci_parse($conn, "select ENAME from emp"); oci_execute($stmt); $i = 0; while (oci_fetch($stmt)) { $i++; $name = oci_result($stmt, "ENAME"); echo $name . "<br>"; } echo "<br>"; echo $i . " Records Selected. Count:" . $p; echo "<br><br>"; } oci_free_statement($stmt); oci_close($conn); ?> Expected result: ---------------- I should be able to run this without encountering any Apache.exe Application error. Actual result: -------------- The error message that I am receiving is: The instruction at "0x6042fdc2" refereced memory at "0x00000010". The memory could not be "read". ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28924&edit=1
