Re: Question on Oracle Web Server

C.M. Low wrote:

> We are about to embark on a web forms application on Oracle Web App
> Server 3 using PL/SQL stored procedures (on Oracle 7.3) via the PL/SQL
> web cartridge. I have 2 questions:

Bad news for you here (I am speaking with OWS v1 experience only though):

> 1) If the user clicks on Stop or Back button while the PL/SQL stored
> procedure is still executing, what will happen to the procedure? will it
> still run to completion, will it detect the Stop action as an exception
> (allowing for a graceful abort in the program), or will it be killed
> abruptly on the spot?

Sometimes (seldom, but still too much) it even keeps using resources (v1.0).You notice after some time, you kill the session.

> 2) If the stored procedure has a bug that results in an infinite loop,
> will the Web Server or Database Server terminate it after a while (based
> on some timeout value)? Is this timeout value configurable? Will such
> an errant procedure cause the entire web server (and/or database) and
> thus all other web applications to 'hang'?

v1.0: the load of your server goes crazy, you have to kill the www_user (or alike) oracle session.If connecting does not work anymore, shutdown immediate.

r u d i
(remove anti-spam measure from reply-address) Received on Fri May 01 1998 - 13:07:23 CEST