By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

How to protect a PL/SQL proc / func from running more than oneinstance simultaenously

P: n/a
Hi NG

is it possible to protect a PL/SQL proc / func from running more than one instance simultaenously ?

Thanks
Peter

Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
there's no inherent mechanism -- you'd have to use a user-defined lock or a temporary table or even a SELECT FOR UPDATE on an appropriate row to prevent concurrent execution

what's the reason?

-- mcs
"Peter Jenny" <Pe*********@cedes.com> wrote in message news:c0**********@rex.ip-plus.net...
Hi NG

is it possible to protect a PL/SQL proc / func from running more than one instance simultaenously ?

Thanks
Peter
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.