OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » ORA-01403: no data found, error unable to fetch row

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-01403: no data found, error unable to fetch row (oracle 11g, windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01403: no data found, error unable to fetch row [message #595168]

Sun, 08 September 2013 18:02

SeniorInvissible
Messages: 34
Registered: July 2013

Member

I am creating a simple data entry form in APEX. I tried creating it 4 times using the same steps, 3 of the 4 times when I ran it I got the following error: ORA-01403: no data found, error unable to fetch row (cant post a picture of it). I recreated it a few times and suddenly it started working but I used the same steps all of the times. Could anyone give me a hint as to the cause of this error?

Report message to a moderator

Re: ORA-01403: no data found, error unable to fetch row [message #595177 is a reply to message #595168]

Mon, 09 September 2013 00:20

Michel Cadot
Messages: 68755
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

ORA-01403: no data found
 *Cause: No data was found from the objects.
 *Action: There was no data from the objects which may be due to end of fetch.

Regards
Michel

Report message to a moderator

Re: ORA-01403: no data found, error unable to fetch row [message #595184 is a reply to message #595177]

Mon, 09 September 2013 01:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You should have run the form in debug mode; it would have told you what caused the error, so it would be possible to investigate it further. Now, as it seems to be working OK, who knows ... maybe it was you who modified something (so your steps weren't exactly the same), or someone entered data that was missing, or ... /forum/fa/3314/0/

Report message to a moderator

Re: ORA-01403: no data found, error unable to fetch row [message #595229 is a reply to message #595184]

Mon, 09 September 2013 09:06

SeniorInvissible
Messages: 34
Registered: July 2013

Member

Thanks guys

Report message to a moderator

Previous Topic:	apex - jquery page tabs - how to switch programmatically
Next Topic:	Form on SQL query, modify query after form is created

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 03 06:48:14 CDT 2025