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

sp = stored procedure?

joe

rgaffuri_at_cox.net wrote:

>what is an 'SP'?
>
>
>>From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
>>Date: 2003/08/04 Mon AM 08:54:31 EDT
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>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
>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> 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 <mailto:wlsh1961_at_yahoo.com>
>> *To:* Multiple recipients of list ORACLE-L
>> <mailto:ORACLE-L_at_fatcity.com>
>> *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
>> <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com>
>> - Free, easy-to-use web site design software
>>

-- 
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

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: ListGuru_at_fatcity.com (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).