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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 18 Feb 2004 07:10:04 -0500
Message-ID: <vbCdnS7ZNpvDy67dRVn iw_at_comcast.com>

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 - 13:10:04 CET

This message: [ Message body ]
Next message: Lisa Tang: "Error in calling external procedure"
Previous message: Ron: "Re: Oracle ODBC Driver"
In reply to: Peter Jenny: "How to protect a PL/SQL proc / func from running more than one instance simultaenously"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message