How to Terminate Query as SQL Plus Does

[Quoted] 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 - 06:41:47 CEST