Stopping a Query taking more time to execute in runtime in Oracle Forms.

Hi,

In the present application one of the oracle form screen is taking
long time to execute a query, user wanted an option to stop the query
in between and browse the result (whatever has been fetched before
stopping the query).
We have tried three approach.
1. set max fetch record in form and block level.
2. set max fetch time in form and block level.
in above two method does not provide the appropiate solution for us.
3. the third approach we applied is setting the interaction mode to
"NON BLOCKING" at the form level.

It seems to be worked, while the query took long time to execute,
oracle app server prompts an message to press Esc to cancel the query
and it a displaying the results fetched upto that point.

But the drawback is one pressing esc, its killing the session itself.
which is causing the entire application to collapse.
Please suggest if there is any alternative approach for this or how to
overcome this perticular scenario.

This kind of facility is alreday present in TOAD and PL/SQL developer
where we can stop an executing query and browse the results fetched
upto that point, is the similar facility is avialable in oracle
forms ,please suggest.

Thanks and Regards,
Suraj

.

Relevant Pages

  • Re: monitorring number of records processed by AS
    ... execute an MDX query which return this measure and compare to the expected ... Have you take a look at the query executed by AS against your oracle ... Data source is ORACLE. ... Data provider is ORACLE PROVIDER for OLEDB. ...
    (microsoft.public.sqlserver.olap)
  • Re: Debug ORA-03113 on Oracle XE
    ... a laptop that runs the Oracle 10g Express ... The query returns no rows with the current data set but it's pretty ... If Oracle XE generates further info I don't know where I ... Usually, when you install Oracle, the UTL_FILE package is installed, EXECUTE is granted to PUBLIC, and a public synonym is created. ...
    (comp.databases.oracle.server)
  • Re: Finally which ORM tool?
    ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: OO4O execute a query against Oracle, VBA Excel 2003
    ... I can execute the SQL with no problem using TOAD on Oracle ... 10G, but for some reason it won't using OO4O, every example that I ... Thanks, but I won't want to run the query in Toad/Or SQL*Plus, I ...
    (microsoft.public.excel.programming)