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: Stop Executing an SQL

Re: Stop Executing an SQL

From: Michael Kurz <Michael.Kurz_at_c-plan.com>
Date: Wed, 20 Oct 1999 15:33:39 +0200
Message-ID: <7ukg64$3kh$1@bnews.gigabell.net>

Hello Edorta

Thanx for the tip !
It Works fine in SQLPlus.

I need a way I can stop a select (or a user aktion) with ADO too. Is there a SQL Command to do that ????

Many Thanx
Micha

Edorta <edortta_at_yahoo.es> schrieb in im Newsbeitrag: 380DA190.15C144ED_at_yahoo.es...
> As far as I know (SQLPlus) you only have to press Ctrl-C to stop
> execution.
>
> Michael Kurz wrote:
>
> > Hello
> >
> > How can I stop (break) the Executing an SQL
> > ( SQL-Worksheet, SQL+ or ADO)
> >
> > I have to wait hour's till the execution is done........
> >
> > Is there an solution ?
> >
> > Why I want to do that:
> > - I do an SQL that returns many Records and I want to stop the output
> > - I Test an SQL but It's not optimized
> > - Somebody (a bad user) executes an bad SQL.
> >
> > Thanx for an answer
> > Micha
>
Received on Wed Oct 20 1999 - 08:33:39 CDT

Original text of this message

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