Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How to stop execution of a procedure when user cancels the request (by pressing stop button)
How to stop execution of a procedure when user cancels the request (by pressing stop button) [message #76708] Thu, 15 May 2003 06:31
Kedar
Messages: 4
Registered: May 2003
Junior Member
Hi,

We often find that users click on stop button on browser when a URL is taking long time produce output.

This happens when the pl/sql procedure invoked by OWAS is really heavy.

Even when user is now no more interested in the output, the procedure continues to execute.

Is there any way to terminate the execution of proc when user is no more connected? (We are using plsql cartridge)

Real problem is, for such heavy procedures, when it does not produce output in some time, users click stop and then REFRESH. This creates multiple instances of the procedure running on the database, putting even more load on the database.

Regards,
Kedar.
Previous Topic: Removing Stored Procedure name from URL
Next Topic: 9iAS Rel2 report server
Goto Forum:
  


Current Time: Sat Sep 19 02:05:59 CDT 2020