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:

 

 

 

 

 

 

 

 

 

  

 

  

 

  

 

Propia

 

 

 

 

 

Eliminar?  

 

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

 

 

 

 

http://rgoracle:8080/i/f_spacer.gif

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
  • component.type: APEX_APPLICATION_PAGE_PROCESS
  • component.id: 4745702752950572
  • component.name: 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.

Legend

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