ID: 9917
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: Oracle related
Description: left open Oracle cursors break mail() function


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.

Previous Comments:
---------------------------------------------------------------------------

[2001-03-22 07:53:59] [EMAIL PROTECTED]
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.

---------------------------------------------------------------------------


Full Bug description available at: http://bugs.php.net/?id=9917


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to