Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!asuvax!ukma!seismo!bonnett
From: bonnett@seismo.CSS.GOV (H. David Bonnett)
Newsgroups: comp.databases
Subject: Cancelling a query in Oracle on Unix
Keywords: Interrupt, Pro*C, V6, Sun, TCP-IP
Message-ID: <49507@seismo.CSS.GOV>
Date: 22 Mar 91 21:08:22 GMT
Sender: usenet@seismo.CSS.GOV
Organization: Center for Seismic Studies, Arlington, VA
Lines: 32


We are looking for a way to cancel a query that is in
progress from within a Pro*C application. It is quite 
possible for our users to cobble up a query that will
not finish for many moons and we want to be able
to kill these off.  We are using the two-task driver
on TCP-IP on Sun 4's with Oracle v6.0.27.8.1.

Some poking around has unearthed the following:
1.) The tcp-ip drivers provides for in/out of band
  breaks; implying that a methods exists at this 
  level.
2.) SQL/PLUS is able to notify the back-end that
   the query is not needed any more.
3.) The back-end does keep running until the query
   completes when called from Pro*C.
4.) Not a word about this appears in all the manuals
  I looked through (DBA, Pro*C, Tcp-Ip, Unix Tech Ref
  etc); although there Is a nice chart on the "Evolution
  of Unix" ;-)

Any pointers or ideas are greatly appreciated

-dave bonnett-   Center for Seismic Studies;  Arlington, VA 
      bonnett@seismo.css.gov :  All standard disclaimers apply.




--
-dave bonnett-   Center for Seismic Studies;  Arlington, VA 
      bonnett@seismo.css.gov :  All standard disclaimers apply.