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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Peter Jenny
    #1

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

    Hi NG

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

    Thanks
    Peter

    Tags: None
    • Mark C. Stock
      #2
      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@ce des.comwrote in message news:c0vdov$q34 $2@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


        Comment

        Previous template Next
        Working...