Kill or Cancel an SQL query from an Apex button
441198Nov 11 2008 — edited Nov 13 2008Hi Folks,
Anybody know how I could create a button to allow users to cancel a query they have submitted. I have an application that allows users to generate SQL and then execute it. The results come back in a report region. However, if the user creates a long-running query, I want to provide the ability to cancel the query from the APEX page. This is further complicated by the fact that the query is over a database link to a seperate 10g database. This is really to try and reduce the load on the Database server if a number of long running queries are performed.
Thanks,
Donal.
Edited by: Donal O Mairtin on Nov 13, 2008 4:19 PM