Help with using Oracle from ASP - using long running stored procedure

we are using ASP with Oracle 9i backend. we need to user procedures that can
take up to 10-15 minutes to run (they been tuned, they are doing alot of
work). Problem is that the page will either time out, or if we remove the
time out they can't use it for the time

is it possible to have the procedure called and then leave it alone,
regardless of what it does (if errors occur we have alternatve methods to trap
that) and have the asp page assume everything is fixed (we will give use an
alert box stating work will be ready in an hour).

or do we have to wait for the procedure to finish

Re: Help with using Oracle from ASP - using long running stored procedure

<<
we are using ASP with Oracle 9i backend. we need to user procedures that
can
take up to 10-15 minutes to run (they been tuned, they are doing alot of
work). Problem is that the page will either time out, or if we remove
the
time out they can't use it for the time

is it possible to have the procedure called and then leave it alone,
regardless of what it does (if errors occur we have alternatve methods
to trap
that) and have the asp page assume everything is fixed (we will give use
an
alert box stating work will be ready in an hour).

or do we have to wait for the procedure to finish
>>

Perhaps have the page in question come up with your explanation of what
is happening and a link to go on from there to do other stuff. But (and
here is the key) have the link open up a new window:



Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!