In general, the deadlock occurs when two or more session is waiting data which is locked by each session. Here we are trying to delete the data which is locked by update statement. so this should be lock(not deadlock). To my understanding, it is not dead lock. Please correct me. I think, i am missing some thing here. Thanks
Originally Posted by tamilselvan
Issue a commit, after the update.
The autonomous transaction tries to delete the row which is not yet committed.