[Fix]-ORA-08177 on select statement
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.