detect and kill my own procedure if it's running

Giganews Newsgroups
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.

Replies