Home » Developer & Programmer » Application Express & MOD_PLSQL » ORA-01403: no data found, error unable to fetch row (oracle 11g, windows 7)
ORA-01403: no data found, error unable to fetch row [message #595168] Sun, 08 September 2013 18:02 Go to next message
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?
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 19345
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 ... ./fa/3314/0/
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 Go to previous message
SeniorInvissible
Messages: 34
Registered: July 2013
Member
Thanks guys
Previous Topic: apex - jquery page tabs - how to switch programmatically
Next Topic: Form on SQL query, modify query after form is created
Goto Forum:
  


Current Time: Thu Jul 31 20:48:56 CDT 2014

Total time taken to generate the page: 0.67404 seconds