Script taking longer than expected to complete: Consequences?

[Colin Steadman]

I've setup a very simple page which allows a group of users to start a
procedure in Oracle from an ASP page (relevant code copied below). I
was led to believe that the processing job was fairly quick and would
only take a minute to complete.

However to my disappointment, having only built and deployed the page
a few days ago, I've already had a call from one of the users who
tells me that its just timed out on them (timeout currently occurs
after 90 seconds). I've made a quick mod to the page and used
Server.ScriptTimeout 600 to give the script plenty of time to
complete.

However I'm now concerned about what would happen if the user
interrupted processing mid-way through by accidently closing the
browser window or something. What would happen on the database in
this situation?

To get around the problem I'm thinking about putting a transaction
around the execution part of the code. But would this work if the all
the SQL is doing is starting an Oracle procedure? I've only ever used
it with straight updates before!

TIA,

Colin
On Error Resume Next

Dim cn
Dim sql
Dim arSQL()

Redim arSQL(3)

arSQL(0) = "begin"
arSQL(1) = " db2acs_inbound_api.LOAD_MANUAL_INVOICES;"
arSQL(2) = " commit;"
arSQL(3) = "end;"

Server.ScriptTimeout 600

Set cn = Server.CreateObject("ADODB.Connection")
cn.open Session("PROVIDER")
cn.execute Join(arSQL,"")

[Ray Costanzo [MVP]]

If the user closes the browser window, the script will continue to run on
the server. Once the request is made to the server, it starts doing what it
has to do and runs until it's finished (or errors out, times out, whatever).
Asuming that you cannot do anything about the duration of the database
operations, perhaps you'll be interested in some of the ideas here.
http://www.aspfaq.com/show.asp?id=2194

Ray at work

"Colin Steadman" <go****@colinsteadman.com> wrote in message
news:40**************************@posting.google.c om...

I've setup a very simple page which allows a group of users to start a
procedure in Oracle from an ASP page (relevant code copied below). I
was led to believe that the processing job was fairly quick and would
only take a minute to complete.

However to my disappointment, having only built and deployed the page
a few days ago, I've already had a call from one of the users who
tells me that its just timed out on them (timeout currently occurs
after 90 seconds). I've made a quick mod to the page and used
Server.ScriptTimeout 600 to give the script plenty of time to
complete.

However I'm now concerned about what would happen if the user
interrupted processing mid-way through by accidently closing the
browser window or something. What would happen on the database in
this situation?

To get around the problem I'm thinking about putting a transaction
around the execution part of the code. But would this work if the all
the SQL is doing is starting an Oracle procedure? I've only ever used
it with straight updates before!

TIA,

Colin
On Error Resume Next

Dim cn
Dim sql
Dim arSQL()

Redim arSQL(3)

arSQL(0) = "begin"
arSQL(1) = " db2acs_inbound_api.LOAD_MANUAL_INVOICES;"
arSQL(2) = " commit;"
arSQL(3) = "end;"

Server.ScriptTimeout 600

Set cn = Server.CreateObject("ADODB.Connection")
cn.open Session("PROVIDER")
cn.execute Join(arSQL,"")

[Colin Steadman]

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in message news:<#l**************@tk2msftngp13.phx.gbl>...

If the user closes the browser window, the script will continue to run on
the server. Once the request is made to the server, it starts doing what it
has to do and runs until it's finished (or errors out, times out, whatever).
Asuming that you cannot do anything about the duration of the database
operations, perhaps you'll be interested in some of the ideas here.
http://www.aspfaq.com/show.asp?id=2194

Ray at work

Much appreciated.

Thanks Ray.

Colin