Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: canceling statement

Re: canceling statement

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Wed, 27 Jun 2001 10:02:11 +0200
Message-ID: <9hc3s6$d5je2$2@ID-54600.news.dfncis.de>

i wanna know, how it can be done programmatically

eg.

client starts query in thread 1
thread 2 cancels the query (in the database!) after a timeout

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B395939.CD5C9D57_at_exesolutions.com...
> Alex Filonov wrote:
>
> > Steffen Ramlow wrote:
> >
> > > how can i cancel a running statement?
> >
> > In sqlplus, CTRL-C. In Forms, look up key help.
>
> Control C may or may not kill a server process.
>
> On NT orakill.exe and on unix kill -9 if you want to be quick and
> deadly.
>
> Daniel A. Morgan
>
Received on Wed Jun 27 2001 - 03:02:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US