Sudden ORA-01422 error
782404Dec 2 2010 — edited Mar 1 2011Hi,
I was running a very simple stored procedure, returning more than one rows and it worked well for months. The procedure returned all the rows fetched from the sql. However, suddenly i got 'ORA-01422: exact fetch returns more than requested number of rows' error after executing the same stored procedure. I did not alter anything inside the stored procedure.
The error message did not tell which line or column referencing to the error.
I hope anyone can help me to solve this. It messes my day.
Thank you.