BreakThread problem.

[planas]

Hello

I have a TOracleQuery with
- Threaded:=True
- ThreadSynchronized:=True
- session.ThreadSafe:=True
- SQL:='call dbms_lock.sleep(60)'

I do this :
- OracleQuery.Execute
5 sec after, i make
- OracleQuery.BreakThread
5 sec after, i try to quit application.
- I need to wait for 50 sec before the process is killed.

Same problem when i make OracleQuery.Session.BreakExecute

What i am making wrong ?

Jean-Pierre

 

[Marco Kalter]

TOracleSession.BreakExecution is not always able to cancel the current operation. For example: a wait for a lock, or an internal sort, or a dbms_signal.wait cannot be cancelled, because the Oracle Server is not responding to break signals at that time.

Apparently this is also the case with your scenario.

------------------
Marco Kalter
Allround Automations