Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

castrogenerisJul 30 2013 — edited Aug 13 2013

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:

 

ORA-01403: no data found

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2013
Added on Jul 30 2013
7 comments
3,854 views