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

i dont understnad what you mean by 'SP'. Reads dont get saved anywhere.

you came from a sql server, sybase background or a shareware database background right? You dont need to lock the table. Oracle provides read consistency. So if you select from a table at 1AM and the query lasts 5 minutes. Someone else updates the table at 1:03AM, you will see the table as it looked at 1AM.

what do you mean by SP?

What is your DB background? They are not identical. Table locking is a big no-no in Oracle. Its unecessary.
>
> From: WLSH <wlsh1961_at_yahoo.com>
> Date: 2003/08/04 Mon AM 02:09:23 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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).