autonomous_transaction

[pranavgovind]

Thanks Tamil, Thanks Dav.

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