Re: how to make a delete statement fail

  • From: Shaun Batterton <shaun.batterton@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 31 Aug 2009 15:46:31 -0400

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2009