Home » SQL & PL/SQL » SQL & PL/SQL » Getting ORA-01422: exact fetch returns more than requested number of rows
Getting ORA-01422: exact fetch returns more than requested number of rows [message #659165] Sun, 08 January 2017 10:58 Go to next message
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.
Re: Getting ORA-01422: exact fetch returns more than requested number of rows [message #659167 is a reply to message #659165] Sun, 08 January 2017 11:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why do you expect us to debug code we can not see?
Re: Getting ORA-01422: exact fetch returns more than requested number of rows [message #659168 is a reply to message #659165] Sun, 08 January 2017 11:32 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you really think that anyone can accurately debug code he does not see?

Also always post your Oracle version, with 4 decimals, as solution depends on it.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Previous Topic: execute immediate
Next Topic: check format
Goto Forum:
  


Current Time: Thu Mar 28 18:24:35 CDT 2024