Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

possible to lock stored procedure so only one session may run it at a time?

temApr 17 2012 — edited Apr 18 2012
Is it possible in 11.2 Oracle database, perhaps using DBMS_LOCK, to lock a stored procedure so only a single session may run this procedure at any moment in time? If so, how to do it?

Edited by: tem on Apr 17, 2012 3:20 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2012
Added on Apr 17 2012
12 comments
8,379 views