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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I cancel a long query in Forms 4.5 or 5?

Re: How do I cancel a long query in Forms 4.5 or 5?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 06 Jul 1999 21:39:42 +0800
Message-ID: <3782071E.764A@yahoo.com>


Daniel A. Morgan wrote:
>
> > You can't catch a user action while performing a query in Forms 4.5. It's
> > because the stupid queryengine waits for the result of the server.
> >
> > Sorry....
>
> No need to apologize but while what you say is correct it is not the entire
> story. On many platforms, such as UNIX, you can use the operating system to
> kill a process. All that is needed is to develop a method of identifying
> which process to kill and an external proc to do it.
>
> Daniel A. Morgan

Why not just attach Forms end-users to profiles which limit there cpu/disk activity per sql call...thus at least if they run amuck - they won't be stuck there too long..

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Jul 06 1999 - 08:39:42 CDT

Original text of this message

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