How to break a query
AleCOct 16 2009 — edited Oct 19 2009We are developing an application client/server using DELPHI with ODAC by DevArt based on OCI and ORACLE (10.1.0.5.0).
Into our application we would like to have the a button to stop a query on the database.
Delphi programmers explain me that they are unable to implement that function because DELPHI/ODAC is unable to stop a query started into a thread: if you start the query into the main thread, DELPHI/ODAC can stop the query.
So they ask me if they can kill the session using the ALTER SYSTEM KILL.....
In other words, we need to simulate the CTRL-C in SQL*Plus.
What do you think about it?
Do you have any suggestion to resolve the problem?
But if there is no DELPHI/ODAC function to do that, what can you suggest to implement it?