oracle 101 guy env: oracle 9i, linux, perl dbi, apache, webpages with javascript
Executing a sql statement from a browser with perl and dbi. Can we kill the job? There are two main scenarios where the option to kill might be nice. The user leaves the browser and, two, box resources get to a point where it is no longer useful to try and finish the job (excessive load on the box). Suggestions? I've never killed an Oracle job before. I assume dbi has a way to get a process/job number and the facility to kill it ... right? Thank you.
