Re: How to Terminate Query as SQL Plus Does

I would think that in C or C++, if you have a child thread in a C/C++ sense, in which you execute your OCI call (perhaps a thread in an Oracle multithreading sense), that the parent C thread could cancel the child thread. I'd be careful to detect and act on the CANCEL key in the parent C thread. I'd also check that cancelling left nothing lingering in V$SESSION or V$SQLAREA (where users_executing>0).

larry_xu_at_ibm.net wrote:

> Hi,
>
> Everybody knows how to terminate a Long Query before it even return the
> first row by clicking the 'CANCEL' on
> SQL*Plus. Or Ctrl-C on Dev2000 application. Anybody ever dreamed that their
> application can also do the same thing.
>
> I had tried the some OCI calls in a second thread on Delphi and C/C++,
> but it does not seems working. On single thread platform like
> Sqlwindows , centura, VB and PB application simply hangs.
>
> how to implemented such a cancel function into application developed using
> 3rd party tools like Delphi, C/C++, SqlWindows
> because normally when you issue a Long Sql the earlist possiblity to stop
> the Query is to wait until application start to fetch
> the first row. for some query, it means days and hours. it is simply not
> acceptable to physically killed application Using task manager
>
> Any suggestions ??
Received on Tue Jul 28 1998 - 21:14:36 CEST