Stop processing query or killing thread

R

runner77

Member
Hello,

I have problem on stopping TOracleDataSet, if it executes SQL query / procedure call for long time. I have TOracle Session in datamodule, property ThreadSafe=true and TOracleDataSet in separated TThread. TThread I cannot kill, if it freeze.

Please help me

WinXP/Win98
Delphi3; Direct Oracle Access 3.3.1
soon : Delphi7; Direct Oracle Access 3.4.6.4
DOA without source codes

------------------
 
Before killing the thread you need to call TOracleSession.BreakExecution. This should lead to an "ORA-01013, user requested cancel of current operation" exception.

Note that not all operations can immediately be cancelled. For example, if your SQL query is performing an internal sort of if your procedure is waiting for a lock, the Oracle Server will not listen to your BreakExecution calls.

------------------
Marco Kalter
Allround Automations
 
You must log in or register to reply here.
Back
Top