OciBreak, BreakThread and so on...

Z

zzato

Member
Hi!
Sometime my users need to stop a query.
If i use threaded query and call
breakthread method, it stop server-side
operation and free related resource?
Otherwise, if i use a thread, and in my
thread call OCIbreak, WHATH i must use
as params for it:

sword OCIBreak ( dvoid *hndlp,
OCIError *errhp );

Exist come prop on ODA to get requested
values?

Tnx for any suggestion.
 
TOracleQuery.BreakThread will do the job. It will call TOracleSession.BreakExecution if necessary (which in turn uses OCIBreak by the way).

------------------
Marco Kalter
Allround Automations
 
It will call TOracleSession.BreakExecution if necessary (which in turn uses OCIBreak by the way).

I need to have separate TOracleSession
object for each query?
Otherwise, breakexecution stop ALL query
that use same OracleSession?

Tnx for your answer

Bye

PS: sorry for previous "bad" reply...
frown.gif
(
 
TOracleSession.BreakExecution will only cancel the currently active operation. This can, by definition, be only one TOracleQuery (or other component). A single session can only perform one operation at a time.

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