RE: How to Lock and unlock a table until SP completes

[Siddharth Haldankar]

You can lock a table   LOCK TABLE table IN    ROW SHARE MODE  LOCK TABLE table IN    ROW EXCLUSIVE MODE  LOCK TABLE table IN    SHARE MODE  LOCK TABLE table IN    SHARE ROW EXCLUSIVE    MODE  LOCK TABLE table IN    EXCLUSIVE MODE    After mode you can put an additional clause of NOWAIT depending upon your need, like LOCK TABLE table IN EXCLUSIVE MODE NOWAIT   After you issue a commit on this table, the lock would be released.   Hope this helps.   With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. #  : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 04, 2003 5:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to Lock and unlock a table until SP completes   Dear List:   How can I lock and then unlock a table? A SP only runs about 2 sec, but during its execution, sometimes there are more records saved to the table the SP is working on, then the SP confused.  I want to be able to lock a table while the SP is executing, and then by the end, release the lock. Is there a way to do this? How? Can any one give me an example?   Thanks     Steven Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software