This discussion is archived
7 Replies Latest reply: Aug 13, 2013 12:35 PM by castrogeneris RSS

How to solve ORA-01403: no data found while updating a record

castrogeneris Newbie
Currently Being Moderated

Hi Guys,


Please help me on this one, I know not where the error is coming from. I'm trying to update a record in a form that edits an equipment inventory, I could not paste the image so is kinda as follows:
























I can edit any field but the TAG (which is the primary key). The error shown is:






ORA-01403: no data found

http://rgoracle:8080/i/htmldb/builder/rollup_minus_dgray.gifTechnical Info (only visible for developers)
  • is_internal_error: false
  • ora_sqlcode: 100
  • ora_sqlerrm: ORA-01403: no data found
  • 4745702752950572
  • Fetch Row from EQUIPMENT
  • error_backtrace: ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 806 ORA-06512: at "APEX_040200.WWV_FLOW_DML", line 336 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 332


any advise will be good, I just can hit the issue.


Thanks in advance.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points