#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2009
    Posts
    1
    Rep Power
    0

    How to Check if Oracle stored procedure already running


    I have a pl/sql stored procedure.Want to prevent procedure from running again if its already running.So how to check Procedure already running or not ?
  2. #2
  3. No Profile Picture
    Choose Life...
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2006
    Location
    Scotland
    Posts
    461
    Rep Power
    512
    Originally Posted by silent123
    I have a pl/sql stored procedure.Want to prevent procedure from running again if its already running.So how to check Procedure already running or not ?

    Have a look at this thread on an other forum...Google is your friend btw, it was the first hit when i entered your exact question!

    http://dbaspot.com/forums/oracle-ser...y-running.html

IMN logo majestic logo threadwatch logo seochat tools logo