Re: how to make a delete statement fail

From: Shaun Batterton <shaun.batterton_at_gmail.com>
Date: Mon, 31 Aug 2009 15:46:31 -0400
Message-ID: <81d313ef0908311246h287e1a6dx77c840a2dff899a_at_mail.gmail.com>

does this count as being locked from another session?

session 1: ALTER SESSION SET ISOLATION_LEVEL = SERIALIZABLE;

session 2: insert into table values (2);

session 1: delete from table where col=2; delete from table where col=value;
*
ERROR at line 1:
ORA-08177: can't serialize access for this transaction

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 31 2009 - 14:46:31 CDT