Hello, Friday, May 16, 2008, 7:22:58 PM, you wrote: oyc> Can we kill the job? There are two main scenarios where the option to oyc> kill might be nice. The user leaves the browser and, two, box oyc> resources get to a point where it is no longer useful to try and oyc> finish the job (excessive load on the box).
oyc> Suggestions? I've never killed an Oracle job before. I assume dbi oyc> has a way to get a process/job number and the facility to kill it ... oyc> right? You can kill a session from an other session using ALTER SYSTEM KILL SESSION Or do you want to kill a job? Both cases are not related to DBI but to Oracle. But you can do it by running the statements with DBI. If you google for "oracle kill session" or "oracle kill job", you will find how to do in SQL*Plus. I usually run that with dbi-do http://search.cpan.org/~timb/DBI/DBI.pm#do cu Wieland mailto:[EMAIL PROTECTED]
