Re: Cancelling a Query

you could use v$session and v$process views. using these two view you could get the process id and kill the process. Tom
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

> --------------------------------------------------------------------------

--


> ------

>

>