SP = Stored Procedure Dave
-----Original Message----- Sent: Monday, August 04, 2003 8:34 AM To: Multiple recipients of list ORACLE-L what is an 'SP'? > > From: "Tanel Poder" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon AM 08:54:31 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: How to Lock and unlock a table until SP completes > > Hi! > > You could also play with set transaction read only, set transaction isolation level > serializable or opening all cursors in beginning of SP and only closing them when > all work is done to achieve consistency you need. > > Tanel. > ----- Original Message ----- > From: WLSH > To: Multiple recipients of list ORACLE-L > Sent: Monday, August 04, 2003 9:09 AM > Subject: 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 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).