How to Check if Oracle stored procedure already running

Dev Shed Forums Sponsor:

November 11th, 2009, 12:44 AM

silent123

Registered User

Join Date: Nov 2009

Posts: 1

Time spent in forums: 43 m 45 sec
Reputation 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 ?

November 12th, 2009, 05:29 AM

scotland87

Choose Life...

Join Date: Oct 2006

Location: Scotland

Posts: 461

Time spent in forums: 4 Days 15 h 7 m 26 sec
Reputation Power: 511

Quote:

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-se...dy-running.html

Viewing: Dev Shed Forums > Databases > Oracle Development > How to Check if Oracle stored procedure already running

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump