Oracle and Stoping Large Queries
| From: | Mark Nold | Date: | Thu, 06 Apr 2000 01:07:28 +0000 |
| Subject: | Oracle and Stoping Large Queries | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-17659@lists.php.net to get a copy of this message | ||
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