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

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" <Peter.Jenny_at_cedes.com> wrote in message news:c0vdov$q34$2_at_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

--
Received on Wed Feb 18 2004 - 06:10:04 CST