Re: Transaction level commits?

In you example (which would have to be
rewritten so that TXN B was handled through a separately declared procedure), you would get a deadlock error detected.

Comments in line.

--

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

Doug Cowles wrote in message <37FED08E.6523AD1C_at_nospambigfoot.com>...
>Maybe..I'm not sure. The essential question is :
>
>TXN A
> Select * for update from x where id =y

• ROW Y is now locked
  > TXN B
  
• A completely independent transaction space
  > update x where id =y
  
• Want to lock row Y, which is already locked
• Owning transaction recognised as hold
• ORA-00060 raised
  > commit
  > END TXNB
  > ??? Is row y in table x still locked for update
  here???????????????
• if TXN B was surrounded by an exception handler
• to trap 00060, then TXN A woudl still be holding
• a lock on row Y
  >
  > update x where id =y
  > commit
  >END TXN A