After the update the row is locked.
Then you try to delete the same row in a autonomous transaction. Oracle is not able to delete, hence you get ora-60 error.
For further reading about dead lock, plz read
http://www.oracleact.com/papers/deadlock.html




Reply With Quote