Oracle and Stoping Large Queries

From: 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

« previous php.dev (#17659) next »