Re: Serialize access to tables

It depends on how you want to use the mutex.

Have a look at the dbms_lock package, this may help to do what you want without even creating a table.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Shelby Cain wrote in message ...


>Is there any way to lock a table (Oracle 8.0.x or 8.1.x) such that only one

>session at a time could access it (even for just reading)?  I need to be

>able to implement some sort of mutex in PL/SQL and this is driving me crazy

>as it seems I can lock a table to deny writes to other sessions -- but that

>does little good for me if I'm updating a value and before I've committed

 it


>another session reads the old value.

>

>Any help or suggestions would be appreciated.

>

>Regards,

>

>Shelby Cain

>

>