Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: detect and kill my own procedure if it's running

Re: detect and kill my own procedure if it's running

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 11 Sep 2006 22:56:09 -0700
Message-ID: <1158040568.73811@bubbleator.drizzle.com>


Akimeu wrote:
> hello group. so i have a stored procedure but do not have dab
> privileges on the db. what i'd like to accomplish, is the following:
>
> 1. within the procedure, before i execute the main logic, check to see
> if another session is executing this procedure. if so, go ahead and
> kill that session and continue executing.
>
> i looked at dbms_application_info... but, that's only part of the hurdle
> it seems. i'd appreciate any feedback on this. thanks in advance.

This has all the elements of a poorly thought out design. But after DBMS_APPLICATION_INFO.SET_MODULE what else do you need? If you find it ... ALTER SYSTEM KILL SESSION.

But I'd recommend you deal with the design issue first.

-- 
Daniel Morgan
Puget Sound Oracle Users Group
Received on Tue Sep 12 2006 - 00:56:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US