Re: RE: [PHP-DEV] Oracle and Stoping Large Queries

Joe, It appears that the query is still processing and hasn't returned a row just yet, but it will run to completion no matter what. Could this be becasue connection_status being broken in 3.0.14? Also would running PHP as a CGI rather than a module be any cleaner? mn Mark Nold markn@alverstone.com.au Systems Consultant >>> Joe Martin <jmartin@analytika.com> 04/06 11:13 pm >>> I ran into the same problem with php 4, and thies and I actually found the same problem with connection_status not being properly initialized. He fixed this in the php 4 code base... When you say the query still runs after the browser has stopped, has the query begun to return results, or is it still processing over at the server at the time the browser stop button is pressed? -----Original Message----- From: Mark Nold [mailto:MarkN@awi.com.au] Sent: Wednesday, April 05, 2000 9:07 PM To: thies@digicol.de; ssb@fast.no; php-dev@lists.php.net Subject: [PHP-DEV] Oracle and Stoping Large Queries Hi guys, I have a PHP 3.0.14 on a Linux box (RH6.1) with Oracle 8.0.5 installed pointing to a Ora 7.3.3 on a remote server. Everything works fine except for when a user runs a large query then hits stop on the browser. The query keeps on running on the backend. This is unfortunate since if i run the same query via SQL*Plus on the linux box as soon as CTRL+C the query stops executing on the back end. This is a problem for me as users can and will run large queries on our intranet then change their mind and stop them and run something else etc... I have checked for ignore user abort and it is not on, also i have tried testing for connection_aborted() and register_shutdown_function() but to no avail. Any ideas? Is this behaviour normal? Is there a solution? Thanks for your time, mn Mark Nold markn@alverstone.com.au Systems Consultant -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net For additional commands, e-mail: php-dev-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net