[Fix]-ORA-08177 on select statement

Wikitechy | 1179 Views | oracle | 28 May 2016

 


ORA-08177 on select statement

Reason for the issue:


  • The error is an output from serializable transactions wherein a row selected for modification already has another transaction with modify operation on it. 
  • This happen in scenarios with read committed isolation level.

Fix:

Setting default isolation level for the connection and connection properties proves a best solution for this issue.



Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise