Bug #9917 Updated: left open Oracle cursors break mail() function

ID: 9917 Updated by: php-bugs@lists.php.net Reported By: andrewmc@tomahawk.demon.co.uk -Status: Feedback +Status: No Feedback Bug Type: Oracle related Operating System: Sequent DYNIX/ptx 4.4.8 PHP Version: 4.0.4 New Comment: No feedback was provided for this bug for over a month, 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". Previous Comments: ------------------------------------------------------------------------ [2002-02-26 17:59:51] mfischer@php.net Please try and see if this is still accurate for the latest version (4.1.1) of PHP. ------------------------------------------------------------------------ [2001-03-23 07:01:49] andrewmc@tomahawk.demon.co.uk closing the cursors was a red herring, it worked for a bit then same problem occurred again. From having done some research and changing some scripts it seems that the problem starts after any PHP script which does putenv() has been run. Removing putenv() from all PHP scripts and setting up the environment in the Apache startup script instead seems to workaround the problem though is not ideal. ------------------------------------------------------------------------ [2001-03-22 07:53:59] andrewmc@tomahawk.demon.co.uk PHP 4.0.4 staticly compiled into Apache 1.3.14 with Oracle 7.3.4 support - configure line as follows: ./configure --without-mysql --with-apache=/usr/local/apache_1.3.14 --with-ora cle=/devuat/oracle7.3.4 --enable-track-vars --enable-sigchild Apache started with PHPRC pointed to directory containing php.ini file with following line: sendmail_path = /usr/lib/sendmail -t -i Start Apache, run PHP script which uses mail() function...this works fine until a PHP script has been run which performs ora_* functions but does not close cursor resources. Subsequent mail() function calls result in no message and the following in the Apache error_log file: : is not an identifier This looks like stderr from /bin/sh (output below) $ strings /bin/sh|grep identif is not an identifier The following code before calls to mail() fixes the problem: for ($i=0; $i<10; $i++) ora_close ($i); Seems that unclosed cursors break mail() More info available if required. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=9917&edit=1