Re: Aborting PL/SQL

From: Ralf Jonas <ralf.jonas_at_gmx.de>
Date: Wed, 15 Nov 2000 08:51:18 +0100
Message-ID: <8utfcm$2oj1r$1@ID-6634.news.dfncis.de>

Hi Mark,

> > is there any chance to abort a long running PL/SQL procedure by
> > another way than 'shutdown abort'? ...
>
> As an alternate it is possible to write a database stored procedure
> that can locate and kill sessions based on passed criteria such as
> Oracle username, OS user name, program being executed and other
> information in v$session. This routine could be called to perform
> the task.

Works fine this way. Thanks a lot.

Ralf Jonas Received on Wed Nov 15 2000 - 01:51:18 CST