Re: how to make a delete statement fail

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

Other related posts: