Pages

Saturday 17 September 2016

ORA-01422: exact fetch returns more than requested number of rows

Cause: 

This can be for one of the following three reasons:
   1. There's a bug in the code and the developer did not realise that you could get more than one row returned;
   2. The data has been hacked rather than using the API so that validation has been broken;
   3. The software is OK, what the user did was OK, but two parallel updates occurred at the same time and neither could see the uncommitted change that the other did - hence not validated correctly.
  4.The number specified in exact fetch is less than the rows returned.
Action
Rewrite the query or change number of rows requested

No comments:

Post a Comment

Code Review

 SOLID Principles S – Single Responsibility Principle There should never be more than one reason for a class to change. O – Open-Closed Prin...