Re: How to stop a running PL/SQL-procedure?

From: Andy Hardy <Andy_Hardy_at_camk.demon.co.uk>
Date: 1997/12/15
Message-ID: <PBZNvAAacRl0MwBf@camk.demon.co.uk>#1/1

In article <3492C454.36E_at_stud.uni-erlangen.de>, Ingo Ruth <ingo.ruth_at_stud.uni-erlangen.de> writes
>Hi!
>
>I'm just rebuilding the schema of my databse with several
>PL/SQL-procedures.
>In one of these procedures I found a bug, but it has already startet -
>so how can I stop only this procedure without stopping the others?
>When I turned to Solaris to get a process-listing with ps -ef I couldn't
>find any of these processes.
>
>So is there any way to stop only one running procedure?
>
>Thanks for any help.
>Ingo.

The PL/SQL procedures are running within Oracle and so won't be seen by the OS.

From within Oracle you could cancel the session which started to run the procedures.

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG

Received on Mon Dec 15 1997 - 00:00:00 CST