Re: Locking a table

[Ronald J Kimball]

On Mon, Nov 11, 2002 at 12:06:23PM -0800, John Gedeon wrote:
> Is there a way to easily lock a table ? so that no updates can happen 
> untill my script is done?
> 
> I am using DBD::Oracle?

Turn off AutoCommit, and use the LOCK TABLE command.

e.g. $dbh->do("LOCK TABLE mytable IN EXCLUSIVE MODE");

To release the lock, call commit().

Ronald