Cancel a running Oracle query
603596Oct 16 2007 — edited Oct 17 2007Is there any way to programmatically cancel a long running Oracle 8i query. I have a search form that allows a user to select from a number of fields and issue a genereated sql query for those fields. Some of the combinations cause the query to take a very long time and use more resources than I would like on the database server. I would like to be able to offer the user the ability to cancel the query if they find it is taking too long to return.
Thanks in advance for any responses.