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!

Fix for ORA-01403 No Data Found in Oracle APEX

jaramillDec 29 2024 — edited Dec 29 2024

This is an error I encountered recently specifically when you run into the error pointing to the "process for Initializing form", and for the life of mean I couldn't figure why it all of a sudden came up as the error did not a appear on other similar pages with similar logic. It turns out when I went to “DELETE” a record from a FORM, it needed to process the delete via a “Processing” process but also a BRANCH to go to another page after all was said and done.

IF it did not have this branch it would revert back to the same page that I did the delete and try to re-query the record I just deleted hence the “NO DATA FOUND” error!

Lesson learned.

Running on Oracle Apex 21.2.3 on Oracle Database 19

Comments
Post Details
Added on Dec 29 2024
2 comments
1,094 views