Re: Cancelling a Query

Hi Martin,

Take a look at 'Database->Maximum Query Time' Form or Block property and at 'Database->Interaction Mode' Form property also.

But the last one could realy affect a performance of your queries...

Hope that helps.

Martin Jones wrote:
>
> 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
> ----------------------------------------------------------------------------
 

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru