detect and kill my own procedure if it's running

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. Received on Mon Sep 11 2006 - 16:08:44 CDT