Re: Cancelling a Query

From: David M. Luo <mluo_at_yesic.com>
Date: 2000/02/16
Message-ID: <V5nq4.25$bn3.721_at_news2.randori.com>#1/1


Call abort_query in the cancel button trigger.

"Martin Jones" <mjones.satisdata_at_btinternet.com> wrote in message news:87n4en$a9$1_at_uranium.btinternet.com...
> Can anyone help.
>
> I have developed an Ad Hoc query tool using Forms6 over the web. This uses
> stored procedures
> to build and execute a query and returns a sample set of rows to the
 screen.
> What I would like is
> that the user can Press a CANCEL button to abort the query if their
> selectivity was bad and resulted
> in the query taking too long.
>
> Is there a simple way I can track the executing query and cancel it on
> demand.
>
> Regards
> Martin Jones
> --------------------------------------------------------------------------
 --
> ------
> Oracle Certified Professional - DBA
> Oracle Certified Professional - Application Developer
> --------------------------------------------------------------------------
 --
> ------
>
>
Received on Wed Feb 16 2000 - 00:00:00 CET

Original text of this message