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();
?>

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.

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?

I went and got the latest version PHP 5.0.1-dev (cli).  I ran the following script from the console and it consistantly hung the php execution.  This is how I executed it at the command prompt (> php.exe -f test.php).
Here is the script I ran.  The object count for my database was just over 10,000 records.

<?php 
    $conn = oci_connect("scott", "tiger", "yourhost");
    $stmt = oci_parse($conn, "select * from all_objects where owner = 'SYS'");
    oci_execute($stmt);
    $count = 0;
    while ($row = oci_fetch_assoc($stmt))
	echo $count++ . " ";
    oci_free_statement($stmt);
    oci_close($conn);
    echo "Executed Query";
?>

I am experiencing the same problem with Apache 1.3.29 and PHP 5.0.0, 5.0.1 and 5.0.2-dev of today (August, 23), so I guess this has not been solved yet.

Is there anything I could to do help debug this problem? I am getting mad trying to work with this configuration but I cannot do otherwise. 
Till now 5.0.0 is the only one that is working from time to time. All other versions hung immediately.

Here?s the setup: windows XP/Apache2.0.50/PHP5.0.0(SAPI)/Oracle 9.2 

Applications interacting with OCI8 (logon, parse, execute, fetch,logoff), which worked as expected using the latest PHP4 release, resulted in an apache2 crash. "Parent: child process exited with status 3221225477 -- Restarting"..

I then upgraded to PHP5.0.1 which seems to have fixed the above crashes but now causes every couple of requests to result in the browser hanging - waiting for the server response. If I hit the browsers refresh button it forces a response. I suspect it has something to do with the OCI8 Logon/Logoff function.  

I have none of these issues when running PHP5 as a CGI.

I have to same problem and I've tried with the following setups:

windows 2K/Apache2.0.50/PHP5.0.1(SAPI)/Oracle 9.2 
windows 2K/Apache1.3.31/PHP5.0.1(SAPI)/Oracle 9.2 

Seems to work fine with CGI.

I have an application running on PHP5, using OCI8, and the only scenario in which I was able have some stability is with 5.0.0 (like Tanis reported above). Even so, it hangs every now and then, and Apache needs to be restarted.

I looked at the change log in 5.0.2 and found nothing about this (serious) problems with the extension. I have upgraded my application to version 5, mostly because of the SOAP functions, but it seems that the OCI8 extension was not ready yet...

I had the same problem but I think I resolve it:
- remove all "putenv" function from your code!
- replace function names : "ocilogon","oci_connect", "oci_pconnect" etc. on: "oci_new_connect"!
No more apache crashes. Tested on 2 machines with
win 2000 php 5.0.1 / 5.0.2.

using php 5.0.3 + apache-1.3.31 + win2000.
the problem fixed changing conection functions ocilogon/ocilogoff by oci_new_connect /oci_close. in the php manual you can read this functions are deprecated for php5 >=.

I have same problem but with IIS SAPI.
Changing OCIPLogon/OCILogoff to OCI_NEW_CONNECT/OCI_CLOSE help to fix problem. Thanks.

I'm having the same problem using Oracle 10g client.  I'm wondering if this has something to do with it?

http://forums.oracle.com/forums/thread.jsp?forum=147&thread=256672&message=761893&q=6372617368#761893

Please try using this CVS snapshot:

  http://snaps.php.net/php5-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.0-win32-latest.zip

Re-tested all scripts with latest version and I am not having any more memory errors.

Thanks,
  Ben