|Subject:||detect and kill my own procedure if it's running|
|Posted by:||Akimeu (Nospam@Email.com)|
|Date:||Mon, 11 Sep 2006|
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.