Getting ORA-01422: exact fetch returns more than requested number of rows [message #659165] |
Sun, 08 January 2017 10:58 |
|
msyogi
Messages: 16 Registered: May 2016 Location: Hyderabad
|
Junior Member |
|
|
Getting error ORA-01422: exact fetch returns more than requested number of rows while executing the select query. Actually the select was written in a cursor. Not sure how it is throwing this error even though it is written in a cursor. And this error is exactly throwing from the date column TRUNC(p.Endo_acc_date) BETWEEN trunc(to_date('8/1/2016', 'MM/DD/YYYY')) and trunc(to_date('8/31/2016', 'MM/DD/YYYY'))
Could you kindly assist me and let me know if you need anything from my end.
|
|
|
|
|