7 Replies Latest reply: Aug 13, 2013 2:35 PM by castrogeneris RSS

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


      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
      • 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.