Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: detect and kill my own procedure if it's running
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 GroupReceived on Tue Sep 12 2006 - 00:56:09 CDT
![]() |
![]() |